Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I was reading some examples of creating Link Tables in QlikView. It seems like when you create this table you should do a LOAD DISTINCT instead of a normal load.
Can anyone explain why please? Thanks
Anyone?
The purpose of a link-table is to connect tables not directly (although this would be quite often possible) and using instead the link-table as a bridge. For this reason will be only distinct values needed. Duplicated values will lead to failures at least by counting-functions and maybe (I'm not sure then normally I didn't use link-table constructs) to further mismatchings then from a sql-view it worked like a join.
- Marcus