Using a Join to identify no matching records from Table Y in Table X

[amcgill2]

Hello Alteryx Community! I am a super new user and was hoping you could help me create a custom workflow to determine the following: 

1. How many unique OPA_ACCOUNT_NUM have no matching parcel_number in the OPA Properties Cleaned.yxdb table?

[apathetichell · Accepted solution]

Is there a column that is in both data sources other than street address? That's obviously not an ideal join candidate. Assuming there is - you can join on it, take the non-matches (left or right anchor depending upon where you feed your data sources) and then run a unique tool.

If there isn't a column in both it gets messier. Especially if something like street address which is non-unique is your join field.

Street and ZIP5 gives you the attached.

[amcgill2]

The parcel number in in OPA Properties Cleaned and the OPA_ACCOUNT_NUM in RTT_SUMMARY, I believe. But I'm not sure how to do that join...

[apathetichell]

That version finds 552 not found records in your .xlsx. Do you want me to add your cleaned excel to this workflow or put it in a separate one?

[amcgill2]

Would you be able to do a separate one? Thank you! Thank you!