Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
-Rob
Use the DISTINCT keyword in the LOAD. For example
LOAD DISTINCT Customer, OrderID, Date etc
-Rob
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.
-Rob