Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to remove duplicate rows frm data sources.

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

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Use the DISTINCT keyword in the LOAD. For example

LOAD DISTINCT Customer, OrderID, Date etc

-Rob

View solution in original post

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Use the DISTINCT keyword in the LOAD. For example

LOAD DISTINCT Customer, OrderID, Date etc

-Rob

Not applicable
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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