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

Question

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.

Cybersecurity_case_studies_LibertyDataSystems_Sample (1).xlsx

RobertOdera · Answer

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!

For_samnucci.yxzp

Yoshiro_Fujimori · Answer

Hi @samnucci ,

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

Workflow

Summary Tool configuration

Output

DuplicatePasswords.yxmd

alexnajm · Answer

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