Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
vinod22kv
Contributor

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