topic Re: Linking 3tables in QlikView

Linking 3tables

honeyasha — Wed, 25 Nov 2020 16:16:04 GMT

I have loaded 3 tables it is not linked instead synthetic key is reflecting in table viewers.

Any one help me to remove synthetic key and link the table.

Re: Linking 3tables

Anonymous — Mon, 18 Jun 2018 18:24:01 GMT

Hello!

There are some ways to avoid synthetic keys:

1) Create your own composite keys that consist of all common fields of tables. And values of fields are stored only once, at one table. For example, KEY1 = field1|field2|field3, table 1 includes key1 and all of fields of the KEY1, and table 2 includes only key value and it's own unique fields.

2) Concatenating your tables at one table ("Concatenate" function). This way you will have many empty values at different parts of your main table.

3) Rename comon fields. For example, add table name at each field name (or use "Qualify" function).

Good luck!

Re: Linking 3tables

vishsaggi — Mon, 18 Jun 2018 19:15:59 GMT

Synthetic keys will be formed if you have > 1 tables with > 1 fields with same name. You can rename the fields or drop to remove synthetic keys keeping at least one field in common in all 3 tables. Can yo u share a snapshot of your Data model where you are seeing this Synthetic keys? Press Ctrl+T to open table viewer to view your model.

Re: Linking 3tables

honeyasha — Wed, 20 Jun 2018 16:33:15 GMT

Hi I am not getting how to attach Data model, below is the common fields in 3 tables

Region,

City

Country

P &L

Thanks.

Re: Linking 3tables

rafatashiro — Wed, 20 Jun 2018 18:23:34 GMT

Hi!

You are getting the synthetic key because there are more than one key between the tables.

Ps: You MUST have just one key field in the tables.

If you can not link the tables with just one field (this case), u can use a LinkTable concept.

Re: Linking 3tables

honeyasha — Thu, 21 Jun 2018 16:23:16 GMT

Hi Anjos,

Thanks for response .

Can you explain the Link table concept.

Thanks,

Re: Linking 3tables

trdandamudi — Thu, 21 Jun 2018 16:30:18 GMT

Please follow the below link and hope this helps..

Link Table