topic How to filter duplicate records in QlikView

How to filter duplicate records

Fri, 28 Jun 2013 08:40:06 GMT

Hello Guys,

I want to load non duplicated fields into QView.

Tried the below code but does not help..please advise?

Load Distinct TradeID

Basically I have duplicated records in my exel and i would like to filter out those duplicate records when loading into QView.

Thanks very much!

Re: How to filter duplicate records

hic — Fri, 28 Jun 2013 08:48:22 GMT

"Load distinct ... " does work, but it compares the entire record, i.e. all fields. So if you still have "duplicates", then they differ in a field value. It could for example be an additional blank space or something similar.

An alternative, if you just want to filter out duplicates of an individual field you could try

Load TradeID, ... From ... Where not Exists(TradeID):

Then you will get only the first instance of each TradeID.

HIC

Re: How to filter duplicate records

vivientexier — Fri, 28 Jun 2013 08:49:03 GMT

Hi,

"Distinct" is a not only about one field. If you are loading 10 fields with different values except for the ID, QlikView will load everything.

Distinct works if your fields combinaison is unique.

Re: How to filter duplicate records

Fri, 28 Jun 2013 09:01:46 GMT

Hello,

I tried the below code:

Load as MOC_TradeID

From

(biff, embedded labels, table is )

Where not Exists(MOC_TradeID);

But…it is giving error when I reload my script..are you able to access please?

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

Re: How to filter duplicate records

vivientexier — Fri, 28 Jun 2013 09:04:31 GMT

Does "MOC_TradeID" is rename in your LOAD ? You have to use the original name.

"Exists" works only if you already have load "MOC_TradeID" before in your script.