sandy666
02-19-2021, 10:51 PM
(question from the web (https://www.mrexcel.com/board/threads/match-across-tables-and-pick-up-values.1162334/))
I have two tables, TableA and TableB (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!
I hink merge tableA and tableB by email column and expand appropriate columns if needed
I have two tables, TableA and TableB (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!
I hink merge tableA and tableB by email column and expand appropriate columns if needed