Forum Discussion
Left outer Join - but only selected columns from both tables
Hi - I feel this should be easy but I can't work it out. I have table A - it has let's say 50 columns, it's quite big. I have table B - let's say it also has 50 columns. I need to merge thes...
Hi naninamu
To merge Table A and Table B with a Left Outer Join while selecting only specific columns:
Remove Unnecessary Columns from Table A:
- In Power Query, select Table A and remove columns you don't need (only keep the 5 columns you want).
Merge the Tables:
- Use Merge Queries to join Table A and Table B on the key column(s) with a Left Outer Join.
Select Columns from Table B:
- After merging, expand the new column from Table B and select only the columns you need.
This way, you limit the columns used in the merge, improving performance.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS