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
Removing duplicates from a working list
-
Joerg Hamacher
- Posts: 121
- Joined: Thu Feb 11, 2016 12:01 am
Re: Removing duplicates from a working list
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
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