Dear all,
I need your help to figure out which tool(s) to use in Alteryx to compare two spreadsheets and find the similarities: I have one large spreadsheet of people and a 2nd one with only the users who use our systems. I need to compare the two spreadsheets using the User ID column and find out which people from the 1st spreadsheet show up on the 2nd file (who from the first list use our systems). And the 2nd thing would be: once I have the names that show up in both spreadsheets, I need to extract the data from the 2nd file using only those names.
Many thanks for your assistance!
Kind regards,
Ioana
