topic Re: synthetic key in QlikView

synthetic key

Tue, 21 Feb 2012 07:37:39 GMT

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

synthetic key

jagan — Tue, 21 Feb 2012 07:45:00 GMT

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.

Re: synthetic key

Tue, 21 Feb 2012 09:46:37 GMT

use qualify statement

Re: synthetic key

Anonymous — Wed, 23 Jan 2013 07:16:53 GMT

John,

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

Rgds,

Nandha

Re: synthetic key

jagan — Wed, 23 Jan 2013 09:53:37 GMT

Hi Nandha,

Please find below example

Qualify B;

Load A,B from x.csv;

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.

Re: synthetic key

Wed, 23 Jan 2013 13:00:05 GMT

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