I have created a sample table below of a much larger dataset.
I want to be able to group each ID and then be able to compare the New and Old Values to see if they are the same, in some cases the order is wrong, or there is a semi colon and space or there are duplicates. How do I clean all this out, so that I can make a more accurate comparison of the two columns?
Best answer by takashi
Once you have split the semicolon-separated values at semicolon and stored the individual values into a list attribute using an AttributeSplitter (Trim Whitespace: Both, Drop Empty Parts: Yes), you can sort the elements with the ListSorter and remove duplicates with the ListDuplicateRemover. Finally you can re-concatenate the elements into a string in semicolon-separated format using the ListConcatenator.
+19Once you have split the semicolon-separated values at semicolon and stored the individual values into a list attribute using an AttributeSplitter (Trim Whitespace: Both, Drop Empty Parts: Yes), you can sort the elements with the ListSorter and remove duplicates with the ListDuplicateRemover. Finally you can re-concatenate the elements into a string in semicolon-separated format using the ListConcatenator.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
