Synthetic Key issue

[Mt3]

Hi,

I am trying to join to tables on load from different sections. However, instead of  connecting two tables directly, I end up getting two synthetic tales  with synthetic keys only. 

Here is exemplary schema I am implementing, would be grateful for any suggestions:

Section 1:

[table1]

Load

A as "A_ID",

B as "B_ID",

C as "C_ID",

D as "D_ID"

from qvdname.qvd (qvd);

Section 2:

[table2]

Load

A as "A_ID",

E as "E_ID"

from qvdname1.qvd (qvd);

LEFT JOIN  ([table2])

Load

A as "A_ID",

H as "H_ID"

from qvdname2.qvd (qvd);

[table3]

Load

B as "B_ID",

F as "F_ID"

from qvdname3.qvd (qvd);

LEFT JOIN  ([table3])

Load

B as "B_ID",

J as "J_ID"

from qvdname5.qvd (qvd);

Result:

Synthetic Table 1 with  A as "A_ID"

Synthetic Table 2 with B as "B_ID"

[ali_hijazi]

Hello

first you need to specify in the left join which table you are trying to make the left join on:
i.e. left join([table1])
load...
or left join(table2)...

after reload check which tables are linked with more than 1 columns and this identifies the synthetic key 

[Mt3]

Thanks! I have omitted table names in the description, although they have been included in the script, sorry for that. 

[ali_hijazi]

I reviewed your script above and I don't see any possibility of having synthetic keys
Is what you have written is the one really in your app
cause here table1 would link to table2 via A_ID and to table3 via B_ID
so there shouldn't be a synthetic key

can you please send me screen shot of the data model viewer?