topic Re: Select distinct rows for many fields in QlikView

Select distinct rows for many fields

Wed, 13 Nov 2013 11:35:27 GMT

Hi,

I would like to have a button/text so as to select rows with distinct values from various fields. That is to select the unique rows for 2/3/4... fields (the combination of these fields to act as a primary key). I know that QV might have a problem and "don't know" which row to select but is there a way to pick one of the multiple ones by picking e.g. the first as they are sorted or by following some defined sorting rule?

Thanks

Re: Select distinct rows for many fields

beristardj — Thu, 21 Aug 2014 22:38:50 GMT

good day.

One idea applies this in two loads.

supose

one table called test

the name of fields

a,b,c,d,e,f

you clean for distinct in fields b,d,f

in first load use hash

fristload:

load

a,b,c,d,e,f,

hash(b,d,f) as key resident test ;

in second load use distinct

secondload:

load distinct key,

a,b,c,d,e,f resident firstload ;

i hope this idea server to you...

Re: Select distinct rows for many fields

jagan — Fri, 22 Aug 2014 03:13:28 GMT

HI,

Can you come up with some sample data and expected output so that it would be easier to answer.

Regards,

Jagan.