Hi, I have a column 'Flag', where there are duplicate values seperated by '_&_' and I want to remove the duplicate values from it. I tried using the AttributeSplitter and creating Lists, but seemed to be too long. Can we do it with some other way? May be regex or list or something new?
Solved
Removing Duplicate values from the column
+2Best answer by takashi
Hi @hellblazer, have you tried a chain of AttributeSplitter, ListDuplicateRemover and ListConcatenator?
+21- Contributor
- Best Answer
Hi @hellblazer, have you tried a chain of AttributeSplitter, ListDuplicateRemover and ListConcatenator?
+2takashi wrote:
Hi @hellblazer, have you tried a chain of AttributeSplitter, ListDuplicateRemover and ListConcatenator?
But, when I see the output of AttributeSplitter and ListDuplicateRemover, no difference is visible, but suddenly the required out is displayed. I am guessing we are creating a list first (AttributeSplitter), removing the duplicates (ListDuplicateRemover) and then concatenating the required results with a seperator (ListConcatenator). Is it?
Where all can we use these combinations or other such combination?
Well, thanks for a quick help @takashi :)
+21- Contributor
takashi wrote:
Hi @hellblazer, have you tried a chain of AttributeSplitter, ListDuplicateRemover and ListConcatenator?
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.