Display specific number in column only once?

[Rayyl]

Hey everyone, I'm relatively new to Alteryx, so I have this simple question:

How can I only display a certain number once in a column? So in the example in the attachment the account number "14151".

Thanks in advance!

Best regards

[FinnCharlton · Accepted solution]

Hi @Rayyl , do you mean you want to remove any 'duplicate' account numbers, so that each unique account number only appears once? If so, you need to use the Unique tool. Drag this tool into your workflow, and select Acc. Number as the unique field. The 'U' anchor will have all unique account numbers, and the 'D' anchor will have any duplicates. Hope this helps!

[Rayyl]

Exactly what I was looking for, thank you very much! :)