Skip to main content
  • EN

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?

Hi @hellblazer, have you tried a chain of AttributeSplitter, ListDuplicateRemover and ListConcatenator?

Hi @hellblazer, have you tried a chain of AttributeSplitter, ListDuplicateRemover and ListConcatenator?

That really works for me.

 

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 :)

 

Hi @hellblazer, have you tried a chain of AttributeSplitter, ListDuplicateRemover and ListConcatenator?

Yes, your observation is correct. That's the procedure exactly I intended.

 

 

Reply


Community Stats

30,469
Posts
115,713
Replies
38,289
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.