How to remove duplicate rows frm data sources.

[#1]

I want to remove duplication in my data sorce.How to do?

[rwunderlich · Accepted solution]

Use the DISTINCT keyword in the LOAD. For example

LOAD DISTINCT Customer, OrderID, Date etc

-Rob

[#3]

Ya.This waht I want.Thnks.

Then I have another scenario such as I need to update new values for already existing rows and also want to add new rows to the same table. at the same time...How to do?

[rwunderlich]

If I understand correctly, it sounds like you want to do an Incremental Load. Check out Incremental Load in the Ref Guide. You can also find a complete Incremental Load example in the QV Cookbook.

-Rob