Solved

remove duplicates values from Excel

mr_fme
Rank
Badge +6

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

icon

Best answer by dustin 27 July 2022, 14:23

View original

2 replies

dustin
Rank
Userlevel 3
Badge +26

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

mr_fme
Rank
Badge +6

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

28,670
Posts
109,367
Replies
36,531
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.