Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an issue with email notifications. If you notice you’re not receiving emails from the Community, please check your SPAM folder and release the emails. This should temporarily resolve the problem while we work behind the scenes to solve the larger issue with our mail sender. Thank you for your patience!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Removing Duplicates to Create Flag

suby
9 - Comet

Hello All,

 

I want to remove duplicates and create columns with flags.

Attached the same workflow with desired Output.

 

Many thanks

3 REPLIES 3
apathetichell
17 - Castor

you're trying to flag which entities had duplicates - right?

 

It's a bit hard to explain how to do this with your attached dataset - but basically you can use a summarize to count the number of times a value occurs and then create a value based upon that with formula and then rejoin it to your original dataset.

ArtApa
Alteryx
Alteryx

Hi @suby - Hope that helps:

ArtApa_0-1622698414453.png

 

suby
9 - Comet

Thanks ArtApa for the solution.

Labels