Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
can we eliminate duplicate values from while loading its self. please let me know.
Regards,
Vinod
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