Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm new to qlikview,to avoid synthetic keys I created the link table by renaming the fields using resident load as per the discussion
Qlik Tips: Rules for creating a Key/Link Table in QlikView
As a result I got the data model like this (fact.png).As per the requirement the dimension tables and link table is connected through the key columns but the fact tables are left alone.I need that fact tables to be connected with link tables through key columns.
Hello,
Maybe put some of your code so that we can have a look at it.
If you rename the fields into dummy values, then no worries about privacy
Antoine
Hi,
PFB attachment.
Hi,
PFA For Example QVW For Creating Link Table.
Regards,
Damu