topic How to remove double entires on LOAD based on one field only in QlikView

How to remove double entires on LOAD based on one field only

Tue, 10 Aug 2010 13:49:29 GMT

Hey,

I need to read an xls file with ZIP codes and coordinates. However there are multiple entries for every ZIP code. How can I load only the first entry and ignore the folowing ones with the same ZIP. LOAD DISTINCT does not work becuase the records have different coordinates and thus are beeing treated as different records.

Best regards,
Georg

How to remove double entires on LOAD based on one field only

jlassell — Tue, 10 Aug 2010 15:08:43 GMT

zipcodes:

load

zip, zip as dupzip, long, lat

where not exists(dupzip,zip)

from zipcoords;

drop field dupzip from zipcodes;

How to remove double entires on LOAD based on one field only

Tue, 10 Aug 2010 16:45:38 GMT

Thanks for pointing me in the right direction.

In fact it is just ...

LOAD A, B, C FROM Table WHERE NOT EXISTS(A);
(Taken from the QlikView manual.)

or im my case I could even do

LOAD A, B, C FROM Table WHERE NOT A = PREVIOUS(A);

Regards,
Georg