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.
Негізгі бет Excel PowerQuery: Match multiple columns between two tables
No video
Пікірлер: 28