how to compare two spreadsheets for similarities
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ivoiculescu2020 ,
You can use the join tool to help you compare both spreadsheets. I'm sharing an example here for you.
Best,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi ,
I want to compare two columns in two separate workbooks (FILE A and File B) by unique ID and find out which are the entries which are not present in file A but present in file B. When we use vlookup in excel, I get #n/a in the formula column for unmatched items. How to do the same in Alteryx?
