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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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”