Forum Discussion
In Power Query, How to add a Column from One Table to Another - if the Tables Share a Common Column?
Hi Anonymous
I knocked together some sample data. Select the LOTS1 tabe and then click on Merge Queries -> Merge Queries as New.
If you want to just add the column to LOTS1, just select Merge Queries rather than Merge Queries as New.
Choose LOTS 2 as the 2nd table. Click on the START_TIME column in both tables to match them.
make sure the Join Kind is Left Outer. Click OK.
You'll get a new column with a table in each row. Click the double headed arrow in the column header to extract the columns in the tables.
Select only the BATCH# column and uncheck the 'Use original column name as prefix'.
Done.
Regards
Phil
Hi Anonymous
I knocked together some sample data. Select the LOTS1 tabe and then click on Merge Queries -> Merge Queries as New.
If you want to just add the column to LOTS1, just select Merge Queries rather than Merge Queries as New.
Choose LOTS 2 as the 2nd table. Click on the START_TIME column in both tables to match them.
make sure the Join Kind is Left Outer. Click OK.
You'll get a new column with a table in each row. Click the double headed arrow in the column header to extract the columns in the tables.
Select only the BATCH# column and uncheck the 'Use original column name as prefix'.
Done.
Regards
Phil
.