Qlik Community

Qlik Sense Data Connectivity

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Shubham_Deshmukh
Valued Contributor

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: What will happen in this case of Link Tables?

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
MVP & Luminary
MVP & Luminary

Re: What will happen in this case of Link Tables?

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

Shubham_Deshmukh
Valued Contributor

Re: What will happen in this case of Link Tables?

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