synthetic key

[#1]

how to overcome the situation of synthetic key while loading files from the oracle database?

[jagan · Accepted solution]

Hi,

If two tables has multiple columns with same name then the Synthetic will form.  To eliminate this you can rename the columns with different names other than the Primary Key column in Qlikview.  Then you can avoid the Synthetic Key.  You can rename the column names in qlikview what ever the database you use.

Hope this helps you.

Regards,

Jagan.

[#3]

use qualify statement

[Anonymous]

John,

Ca you explain how tio ue Qualify statemnt with an example? Bcoz i have many tables with same field name.

Rgds,

Nandha

[jagan]

Hi Nandha,

Please find below example

Qualify B;

X:

Load A,B from x.csv;

Y:

Load A,B from y.csv;

Now B in table X is renamed as X.B and B in Y is renamed as Y.B.

Hope this helps you.

Regards,

Jagan.

[#6]

Hi vitalguar,

You can use :

1) Qualify and unqualify statement to eliminate the synthetic keys completely from the data model.

2) Identify the fields required for linkages between the tables and rename the rest,from the synthetic key.

3) If you have to eliminate multiple synthetic keys from the data model,then create a linktable.

Hope this helps,

Regards,

Snehal Nabar