Excel PowerQuery: Match multiple columns between two tables

Опубликовано: 24 Октябрь 2024
на канале: Your Excel Solution

53,484

444

Matching (joining) multiple columns between two tables in Excel PowerQuery.

Note:
Try "Inner" Join instead of "Left Outer" to skip the filtering step later on.
"Left Outer" will keep ALL records from Table A, even those which do not have a match in Table B.
"Inner" will keep only the records from Table A which have a match in Table B.