Join two tables with several columns from a repository

Question

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 · Answer

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).

Samuel_K · Answer

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.

Qiu · Answer

@caltang 
It is very nice of you! 😁