Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vinod22kv
New Contributor III

how to eliminate duplicate values from while loading

Hi

can we eliminate duplicate values from while loading its self. please let me know.

Regards,

Vinod

1 Reply
MVP
MVP

Re: how to eliminate duplicate values from while loading

Can you be a bit more specific about your issue and the requested outcome?

To eliminate duplicate records, you can use a distinct load:

LOAD DISTINCT

     FieldA,

     FieldB,

...

FROM ...;

To only load the first record in load order for a specific non-key field value:

LOAD

     FieldA,

     FieldB,

...

FROM ...

WHERE NOT EXISTS(FieldA);

edit: or maybe something completely different depending on your requirements

Community Browser