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.
The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs.
If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.
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.