Cleaning up data getting unique list

I have a column of data among many with each record displaying information as below, (serial number is not part of the data)

1. Apple,Orange,Apple,Orange

2. Apple,Apple,OrangeOrange,Grapes

3.Grapes,Grapes,Grapes,Grapes

I would like it to display only the unique values as below (serial # is for reference only)

1. Apple,Orange

2. Apple,Orange.Grapes

3. Grapes

What is the quickest and most efficient way to do this?

Thanks,

Designer Cloud

Accepted answers

ShankerV

Hi @V-GEe7

One way of doing this.

1. Record ID tool

2. Text to Columns

3. Unique tool

4. Summarize tool

Screenshot 2024-05-01 194348.png

Step 1:

1 photo.png

Step 2:

2 photo.png

Step 3:

3 photo.png

Step 4:

4 photo.png

Many thanks

Shanker V

All comments

ShankerV

Hi @V-GEe7

One way of doing this.

1. Record ID tool

2. Text to Columns

3. Unique tool

4. Summarize tool

Screenshot 2024-05-01 194348.png

Step 1:

1 photo.png

Step 2:

2 photo.png

Step 3:

3 photo.png

Step 4:

4 photo.png

Many thanks

Shanker V

cjaneczko

This is one way. Use a Text To Columns and configure it to split to rows. Then use the Unique tool to find unique values, then use the Summarize to group on Record ID and Concatenate the field. Add a sort tool after it by Record ID if you want it back in the original order.

usmanbashir

@V-GEe7 - please see attached workflow. Hope this helps!

uniqueList.yxmd

V-GEe7

Thank you all for a quick response.

Really appreciate it

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335