topic Re: delete duplicates by a key in QlikView

delete duplicates by a key

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a table of 5 fields, but I my key is 3 fields, I don't want to have duplicates by this 3 fields.

I want to sort by this 3 fields and eliminate duplicates

How can I do it?

Thanks

Gysbert_Wassenaar — Mon, 11 Apr 2016 12:10:34 GMT

Perhaps like this:

LOAD

Field1,

Field2,

Field3,

Field4,

Field5,

Autonumber(Field1, Field2, Field3) as Key

FROM

...source_data...

WHERE

NOT EXISTS (Key, Autonumber(Field1, Field2, Field3) )

;

DROP FIELD Key;

jlongoria — Mon, 11 Apr 2016 15:23:50 GMT

I can think of a couple of things you may want to do but I'm not sure. Can you post sample data and sample desired results?