This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi @Akash__on if you bring on a 'Unique' tool and tick Name, Gender and DOB in the 'Column Names' section, the duplicates will then come out of the bottom (D) anchor when you hit run. This will show all fields as you requested.
@Kurohits you are joining on names and there are 4-5 rows with each name in the main data, which will multiply the join and will produce exaggerated results as the name is not a unique column to join on. This will not work, I already tried this.
Have you tried the workflow. Because I am using summarize tool and filter tool to match the condition. Also check the below screen shot. I have added some more duplicate names and it would work perfectly.
I would still recommend using the Unique tool. It gives you the first unique on one output and the rest of the duplicates on the other output. You can then join together to get all the records or just add tools from before the Unique tool.
If this post resolves the question, would you be so kind as to "Select as Solved"?. This will help other users find the same answer/resolution and help the community keep track of answered questions.