Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
KirstenKa
Creator II
Creator II

Remove duplicates with upload

Is it possible to already in the upload script remove duplicates, similar to how this works in excel:  Data/Remove duplicates and that you can select a value based on which you would like to deduplicate

Labels (1)
2 Replies
Chanty4u
MVP
MVP

Try this 

LOAD DISTINCT

    Field1,

    Field2,

    Field3

FROM

    .......

KirstenKa
Creator II
Creator II
Author

Thanks how should I define the value based on which it should deduplicate. In my case it is value “Trading Co”