Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
in script:
sort by colum and load * where previous(colum)<>colum;
Marcus
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.