Identify Missing Items from Two Data Sets
- 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
Hi,
I have two different excel sheets with a common field, both sheets have the column name as same. I need a workflow to show me where they share the same info from the common field and where they contain items that the other sheet does not. I'm sure this is an easy task but I'm only new at this!
- Labels:
- Data Investigation
- Join
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Create a primary key if needed.
transpose both sheets (keeping primary key if needed).
Join on name/value (and primary key if needed)
outer two anchors are unmatched entries.
warning::::: for unique values you will get multiple joins for each item ie if you have ten entries on one side with name of "account" and value of "US Ledger" and 15 entries on the other side with name of "account" and value of "US Ledger" you will end up 150 records.. Alteryx does not make an assumption about which is the "correct" entry to match.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Use join and join on basis of all column
if the same , then will appear in J else in L arrow
