Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vinod22kv
Creator
Creator

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
swuehl
MVP
MVP

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