urgent request

[#1]

Hi,

As I have a qvd that has the same record twice like if the orginal recrod like 100 means it has 200 how to remove the duplicate records

pls advice

[#2]

Hi,

Use Distinct() method to load originals only without duplicates in the script.

for ex:

Load Distinct(id)

from table;

This may help you.

-Charitha.

[tresesco]

Load Distinct

[engishfaque]

Dear Chriss,

Kindly, find attached document.

Kind regareds,

Ishfaque Ahmed

[noman212]

Hi

You can use incremental load to avoid duplication in records if your database update on daily basis...

otherwise use distinct as mentioned in above reply.