Hello,
I have :ColA with n items. In :ColB there are string values. Once :ColB is changed to data type Expression, I’m able to use Words() to change the strings into a list. Then I use Sort List() to alphabetically sort the lists.
I want to compare the lists in :ColB between the n items in :ColA. Creating a subset of if both n items in :ColA share a common. Example, ItemA and ItemB in :ColA share an exact match of a list in :ColB.
Using the Rows > Row Selection > Select Duplicate Rows functionality does not return what I expect when :ColB is selected. I would expect, that if I use this functionality, create a subset of the automatically selected “duplicate” rows, and then sort :ColB, either ascending or descending, that I would find pairs of rows with the exact same lists. This is not the case. Each list is unique.
Any ideas of how to identify potential duplicate matches of lists for each n items in :ColA?
This will all be coded in JSL, I just need to know what's going on before I proceed.
