topic Join table with a common key in QlikView

Join table with a common key

Black_Hole — Sat, 16 Nov 2024 03:35:32 GMT

Hello all,

I would like to join two tables with a common key, but when I look for the join table named Service, I don't find it.

Please could you help me to correct what I do wrong in my join.

Below the structure of my script:

Table_1:

Load

Company,

Country;

SQL SELECT *

FROM SERVERNAME LIBRARY AA;

Table_2:

Load

Date,

Customer,

Company;

SQL SELECT * FROM SERVERNAME LIBRARY BB;

LEFT JOIN(Table_1)

Service:

LOAD * RESIDENT Table_2;

Thank you in advance for your help.

anushree1 — Tue, 14 May 2019 09:32:36 GMT

join takes the name of the table that it inherits the join from so in your case table 1 will have the result of join with your Service Table

Black_Hole — Tue, 14 May 2019 11:30:10 GMT

So, If I want to create in a third table the join between Table_1 and Table_2.

Please could you advise how I can do that.

Thank you in advance for your help.

Black_Hole — Tue, 14 May 2019 14:39:49 GMT

Hello all,

I review my first script to join two tables. I take for support the topic from here.

But, in my table my join is not considered.

Please could you help me to resolve my issue.

JOIN_TABLE:
NOCONCATENATE
LOAD *
RESIDENT CTB;
INNER JOIN (JOIN_TABLE)LOAD * RESIDENT CUST;

IN_CTB:
NOCONCATENATE
LOAD *
RESIDENT JOIN_TABLE;
DROP TABLE JOIN_TABLE;

JOIN_TABLE:
NOCONCATENATE
LOAD *
RESIDENT CTB;
OUTER JOIN (JOIN_TABLE)LOAD * RESIDENT CUST;

OUT_CTB:
NOCONCATENATE
LOAD *
RESIDENT JOIN_TABLE;
DROP TABLE JOIN_TABLE;

Thank you in advance for your help.