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.
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
Hi @samnucci ,
You can also use Summary tool and connect it with the original data.
Workflow
Summary Tool configuration
Output
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!