What will happen in this case of Link Tables?

[Shubham_Deshmukh]

Hi Qlikers,

Need solution to resolve this , if I have same field in 2 fact tables (field1 is present in Fact1 and Fact2 only) after link tables,

Rgds,

Shubham

[Gysbert_Wassenaar · Accepted solution]

If you do nothing then you will get a synthetic key.

One solution is to rename Field1 in table Fact1 to Fact1.Field1 so it no longer has the same name as Field1 in table Fact3.

Another solution is to concatenate the tables Fact1 and Fact3 into one table (and optionally concatenate Fact2 as well so you have only one fact table left).

Or you could create a different key field instead of %Key_Field and include Field1 in the link table instead of the two fact tables.

[Shubham_Deshmukh]

Ya, I am aware about the scenario that it will create synthetic key of %key_field and Field1 if I dnt rename it.
Wanted some different suggestions other than renaming the fields.
Thanks for valuable suggestions.

Rgds,
Shubham