How to remove duplicates

[Learner09]

Hello All,

I am working on the Alteryx flow and struck at one point, where I have duplicate values appearing for the same customer, and I wanted to consider only a single value for each customer. Could anyone please take a look at the attached file and help to resolve my problem.

[atcodedog05]

Hi @Learner09 

Here is how you can do it.

Workflow:

Hope this helps : )

[binuacs]

@Learner09 

[atcodedog05]

Hi @binuacs 

This is definitely the better way I guess somewhere I missed it 😅

[atcodedog05]

Hi @Learner09 

Just adding to the above @binuacs  solution. If you don't groupby on customer ID this solution will retain your data sorting order.

Hope this helps : )