Identify Missing Items from Two Data Sets

Question

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!

Raj · Answer

Use join and join on basis of all column

if the same , then will appear in J else in L arrow

apathetichell · Answer

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.