I have two tables, TableA and TableC (both the result of Power Queries against separate source files) - they have one common column (email_address) - then a number of columns ...
I want a Power Query that creates TableC that starts with TableA - with columns from TableB populated if there is a match on the email_address (and if there is no match "null" is OK, but "No Match" would be even better) ...
But I can't get my head round how to do this in Power Query (I have INDEX/MATCH working, but need it dynamic hence a Power Query)?
I know I need to create custom columns for the columns from TableB, but it's the actual query I'm struggling with!
Any thoughts ...
Many thanks ...
I want a Power Query that creates TableC that starts with TableA - with columns from TableB populated if there is a match on the email_address (and if there is no match "null" is OK, but "No Match" would be even better) ...
But I can't get my head round how to do this in Power Query (I have INDEX/MATCH working, but need it dynamic hence a Power Query)?
I know I need to create custom columns for the columns from TableB, but it's the actual query I'm struggling with!
Any thoughts ...
Many thanks ...