Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.