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...
Option b is definitely not advisable. From a performance perspective, but also from a code structure perspective.
Option a and c are similar in most respects I think. Although I would probably remove the unwanted columns before the merge, from a maintainability perspective. I don't think perfromance would be very different.
Option c would be my preference from a code structure an clarity perspective.
Option d I don't know. I am not using PBI, only PW in excel sometimes combined with Power Pivot.