Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Black_Hole
Creator II
Creator II

Join table with a common key

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.

Labels (3)
3 Replies
anushree1
Specialist II
Specialist II

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
Creator II
Creator II
Author

Hello @anushree1,

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
Creator II
Creator II
Author

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.