Join two tables with several columns from a repository

[Samuel_K]

Hi all,

Im looking for an output as below. Currently, there is a solution in place, however, its not very handy and does not directly show the "mismatches".

Current solution:

If someone knows a more elegant solution, esp. showing the "non-matches" going to into Left, highly appreciated!

Thanks in advance

Samuel

[caltang]

Hi Samuel @Samuel_K 

Are you asking for a way to find out what didn't join? If so, I did something here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Need-to-find-not-matched-colum...

Idea courtesy of @Qiu 

[Qiu]

@caltang 
It is very nice of you! 😁

[Samuel_K]

Hi @caltang

looking for a better way to join the two tables (columns + repository) in one go and moving the "non-matches" to a separate output.

[caltang]

Then I would suggest for you to try my link - that will give you your Joins, and those that did not Join. 

You can even make it a Standard Macro (AKA your own tool).