I want to remove duplication in my data sorce.How to do?
Use the DISTINCT keyword in the LOAD. For example
LOAD DISTINCT Customer, OrderID, Date etc
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?
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.
Retrieving data ...