Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Distinct values

Hello Community members,

I have a colum in my straight table in which the values are repeating , how to avoid the duplicate values. Can anyone please suggest me

Regards,

Ramesh

2 Replies
MEllinghausen
Creator III
Creator III

in script:

sort by colum and load * where previous(colum)<>colum;

Marcus

Gysbert_Wassenaar

If they are repeating then the records are not unique. This can happen when for example you format a date as a month. The underlying date values are still dates, but the display format is month. That's when you see repeating month values because the actual values are still distinct dates. Check if that's the case in your document. You may have to create extra fields in the script, for example month(MyDate) as Month instead of date(MyDate, 'MMM') as Month. The latter only changes the display format, the former creates a new Month field with distinct month values.


talk is cheap, supply exceeds demand