Removing Duplicates to Create Flag

[suby]

Hello All,

I want to remove duplicates and create columns with flags.

Attached the same workflow with desired Output.

Many thanks

[apathetichell]

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 · Accepted solution]

Hi @suby - Hope that helps:

[suby]

Thanks ArtApa for the solution.