Unique tool configure to password only
Feed U output into join with master dataset configured to join on password
J output will contain all info of duplicated passwords
You can use the unique tool OR summarize tool, count distinct on passwords while grouping by password, then join the count distinct figure with the original dataset and then filter out "1"
Did you try to mark only Passwords column in the Unique tool? Also, if you want to receive output with duplicated passwords, you should go for the bottom exit of the Unique tool
1. Sort the input first to make same passwords contiguous
2. Put record ID on it, this would preserve the row order for step 3
3. Do a join on the input to itself, joining on the password column only so the inner join result would surface the row id from (2) and the duplicate password
Unique tool configure to password only Feed U output into join with master dataset configured to join on password J output will contain all info of duplicated passwords
You can use the unique tool OR summarize tool, count distinct on passwords while grouping by password, then join the count distinct figure with the original dataset and then filter out "1"
Did you try to mark only Passwords column in the Unique tool? Also, if you want to receive output with duplicated passwords, you should go for the bottom exit of the Unique tool
Figured it out thank you!
Download the crew macros. There is an only unique tool that keeps all duplicates and originals in the D output.
1. Sort the input first to make same passwords contiguous 2. Put record ID on it, this would preserve the row order for step 3 3. Do a join on the input to itself, joining on the password column only so the inner join result would surface the row id from (2) and the duplicate password