Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jblomqvist
Contributor II

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

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

2 Replies
jblomqvist
Contributor II

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

Anyone?

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

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

Community Browser