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.
I was trying to fetch unique values from a table. But I found it was not as easy as I thought. Please share with me your ideas.
Requirement: This input table(Alteryx doubt.xlsx) contains Name of boys on the left side and Name of girls on the right side.
I want to extract unique Boy-Girl Name pair rows from the Input Table. See the Expected Output here. A boy's name should not repeat in the first column of output, and a girl's name should not repeat in the second column of output.
It looks like an iterative macro is needed to solve this scenario.
Edit: I have uploaded bigger sample data 'Actual Data -4K+ entries.xlsx'
Hi @MeganDibble, Thank you for lookin in to this. This solution works for this data set. But my Actual data contains around 4000 pairs. When I ran this workflow using my Actual data. Some of the required entries were being excluded through the duplicate outputs of unique tools. I have uploaded Actual data here. At the end of the workflow add 2 unique tools. One for checking duplicates in boys name and second one is for checking duplicates in girls name.