topic Re: Synthetic Key issue in App Development

Synthetic Key issue

Mt3 — Mon, 21 Feb 2022 11:03:24 GMT

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"

Re: Synthetic Key issue

ali_hijazi — Mon, 21 Feb 2022 10:45:11 GMT

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

Re: Synthetic Key issue

Mt3 — Mon, 21 Feb 2022 13:12:01 GMT

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

Re: Synthetic Key issue

ali_hijazi — Mon, 21 Feb 2022 13:56:01 GMT

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?