Linking 3tables

[honeyasha]

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.

[Anonymous]

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!

[vishsaggi]

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.

[honeyasha]

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

Region,

City

Country

P &L

Thanks.

[rafatashiro]

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.

[honeyasha]

Hi Anjos,

Thanks for response .

Can you explain the Link table concept.

Thanks,

[trdandamudi]

Please follow the below link and hope this helps..

Link Table