In Excel Power Query I am trying to match two tables where one column should match (i.e. GUID), but the other shouldn't (i.e. Value) so that I end up with only the different values from the join/merge.
So the equivalent in SQL would be this:
Is this possible at all or will I need to use some kind of INDEX MATCH or VBA code to achieve this?Please Login or Register to view this content.
Attached you will find an example file with the result (green header) that I expect.
Bookmarks