topic Re: Load Distinct Resident not working in QlikView

Load Distinct Resident not working

jduluc12 — Fri, 02 Apr 2021 17:01:41 GMT

Hi,

This is my script.

[one]: LOAD * INLINE [ list, amt, key 1, 2, 1-2 1, 4, 1-2 2,3, 2-3 ]; NoConcatenate [two]: load Distinct key, list, amt Resident one; drop Table one;

I was expecting the duplicate keys to drop in table two but they did not.

what am I missing here?

Re: Load Distinct Resident not working

Frank_Hartmann — Fri, 02 Apr 2021 17:58:19 GMT

try this:

tmp: LOAD * INLINE [ list, amt, key 1, 2, 1-2 1, 4, 1-2 2,3, 2-3 ]; NoConcatenate DISTINCT: LOAD distinct key, list, amt Resident tmp; Final_DISTINCT: NoConcatenate LOAD * Resident DISTINCT Where key <> Previous(key) Order By key; DROP Tables DISTINCT,tmp;

Re: Load Distinct Resident not working

Or — Fri, 02 Apr 2021 19:37:33 GMT

Distinct applies to an entire line, not to a single field. Since your lines are not duplicates due to a different amt value, they won't be removed by the DISTINCT.

Which of the two lines would you expect to be kept in this scenario? Or should the line be 1, 6, 1-2 because of sum(amt)?