Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove Duplicate values

I have duplicate values in my table, and I am trying to remove them, I have used Distinct load on both the table and the Generic Load Table.  Distinct Values 2.gif

1 Solution

Accepted Solutions
joshabbott
Creator III
Creator III

Try trimming your field.  It looks like this is a list box, so the 'Field' under 'General' could be an '<Expression>' that equals =Trim(YourFieldName) or better then that, if this is the issue, you could trim it in the script so all of your data is trimmed

View solution in original post

3 Replies
maxgro
MVP
MVP

better if you can post your qlik doc

joshabbott
Creator III
Creator III

Try trimming your field.  It looks like this is a list box, so the 'Field' under 'General' could be an '<Expression>' that equals =Trim(YourFieldName) or better then that, if this is the issue, you could trim it in the script so all of your data is trimmed

Not applicable
Author

Thank You!