Why do you have to do a DISTINCT LOAD when creating a Link Table?

[jblomqvist]

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

[jblomqvist]

Anyone?

[marcus_sommer]

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