Table Joins using 2 common fields

[sureshbaabu]

Hello,

I have a requirement to join 2 tables using 2 common fields.

My current script is as below: (Joined (left joined) two tables using column A)

Table1:

LOAD A,B  from Table1.xls;

Table2:

left join(Table1) LOAD A,C,D from Table2.xls;

***After joining my Table1 have A,B,C,D

Requirement: To join Table 1 and a new table 'Table 3' using A and C columns,

Table3:

LOAD A,C,X,Y  from Table3.xls;

When I load as above, it creates a Synthetic table using A and C - since it has more than 2 common fields.

So, I was trying to create a composite key using A and C (A&','&C as Key)

When I create the key on Table 1, Qlikview does not recognize column C, since C is coming from Table2.

I wanted create a new table (Say-Table 4) that holds all data after left joining Table2 with and Table1 as above and then create a composite key on Table3 and Table4

Could you please help me with the process to achieve the same?

Thank you

[#2]

Glad to help, If you can mark Danielact's question as correct then other people with similar queries will be able to look at this discussion for the answer