How to Fix repeating number

[Learner09]

Hello All,

I am working on Alteryx flow and struck at one point, where I have to delete the repeating number of Sales. Please see the attached example sheet for the details, and provide a solution for the same.

[atcodedog05]

Hi @Learner09 

Here is how you can do it.

Workflow:

Use Multi-row formula tool to keep only 1st occurrence and change rest to "-"

Hope this helps : )

[Jean-Balteryx · Accepted solution]

Hi @Learner09 ,

Here is a workflow doing what you need.

It removes duplicates and sorts data.

[Learner09]

@Jean-Balteryx  Thank you!

[atcodedog05]

I guess i missed out for not using data cleanse tool to clear the string 😅

[Jean-Balteryx]

@Learner09, you are welcome !