In Power Query, How to add a Column from One Table to Another - if the Tables Share a Common Column?

Hi Anonymous 

 

Download example PBIX file

 

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