How to create a workflow that shows duplicates without removing while displaying the row
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @samnucci ,
You can also use Summary tool and connect it with the original data.
Workflow
Summary Tool configuration
Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!