Skip to main content
  • EN

Hi,

 

I have one column in my excel file that show tha values like below:

 

VARIEDADE

 

ABB4, ABB2, ABB4, ABB5

ABB4

ABB2, ABB5

ABB2, ABB2

ABB4, ABB4, ABB4, ABB4

 

The two last lines have the same value separated by comma. I would like to simplify like below:

 

ABB2

ABB4

 

How Can I do this?

 

Thank´s

I would break the values out into a list using AttributeSplitter, remove the duplicates via ListDuplicateRemover, then concatenate the unique values back into the original attribute using ListConcatenator.image

I would break the values out into a list using AttributeSplitter, remove the duplicates via ListDuplicateRemover, then concatenate the unique values back into the original attribute using ListConcatenator.image

Thank´s very good!!

Reply


Community Stats

30,166
Posts
114,512
Replies
37,820
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.