Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

What will happen in this case of Link Tables?

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,

link tables.png

 

 

 

 

 

 

 

Rgds,

Shubham

Labels (3)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Specialist
Specialist

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