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

data quality, clean puntuaction, spacing

hi everybody,

how to clean dirty values that make me duplicate the values of other fields?

 

thank you

 

Labels (1)
3 Replies
rubenmarin

What to do with duplicated values should be also a business decission to set the conditions on wath data has to be retrieved when there are duplicates.

 

As a simple fix you can add "Where not exists(Code)" before the semicolon that cleses the LOAD instruction:

LOAD ...

FROM ...

Where not exists(Code); // It will keep only the first row of each Code, other rows with the same Code are not loaded.

Billy_u
Creator
Creator
Author

thank you for the answer but instead of queues what should I put

rubenmarin

Hi, sorry for long delay but I don't undestand your question