How to create a workflow that shows duplicates without removing while displaying the row

[samnucci]

Hello, In this data set I'm trying to identify duplicates in a data set which are the passwords. In the end I want to display the username in which the password in connected to. I have connected the data set in excel. Any help is greatly appreciated.

[alexnajm]

Check out the Unique Value option in the Tile tool! It'll give a Tile Num (i.e. a number to identify each group) and a Tile Sequence Number which will indicate how many of that value there is

[Yoshiro_Fujimori]

Hi @samnucci ,

You can also use Summary tool and connect it with the original data.

Workflow

Summary Tool configuration

Output

[RobertOdera]

Hi, @samnucci 

If I understood your requirements correctly, you need to identify both duplicate UserName and Password, right?

Kindly consider generating the frequency tables below.

I hope you find this helpful - Cheers!