Removing duplicates from a working list

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
Joerg Hamacher
Posts: 121
Joined: Thu Feb 11, 2016 12:01 am

Removing duplicates from a working list

Post by Joerg Hamacher »

Hi,

I have to read a lot of data into a working list with a lot of fields.
It is possible that at the end some of the list entries contain completely the same values in all of the single fields.

Before processing the list, I would like to identify these duplicates and remove them from the list.

How can this be done easily?

Best regards,
Joerg
User avatar
Dino
Posts: 474
Joined: Fri Jul 19, 2019 7:49 am
Location: Robbinsville, NC
Contact:

Re: Removing duplicates from a working list

Post by Dino »

If you take the word "easily" from the question I may have some ideas... :)

No idea how many fields or what types or how different, but if you want to compare many with many an old trick was to use fields overlapping others using an array. Of course that will work better for strings or numbers of same size and after sorting the list for all these fields so you can compare current with previous value read after moving to the array for overlapping

https://docs.lansa.com/16/en/lansa065/c ... 9_0030.htm
Post Reply