Forum Discussion
Get value from another table
Hi Anonymous ,
In Power Query, select your Table1 query.
Go to the Home tab > Merge Queries.
In the top preview section of the dialog, select the [ID] column.
In the bottom preview section, select Table2 from the dropdown list and also select the [ID] column from here.
Leave the join type as Left Outer for now, you can always change it later.
Pete
Hi Anonymous ,
In Power Query, select your Table1 query.
Go to the Home tab > Merge Queries.
In the top preview section of the dialog, select the [ID] column.
In the bottom preview section, select Table2 from the dropdown list and also select the [ID] column from here.
Leave the join type as Left Outer for now, you can always change it later.
Pete
Hi Pete! Thanks for your reply! What if Table2 has other columns that I don't want to be included in Table1? Sorry I didn't give a complete picture in my earlier post.
No problem. Once the merge is complete, it will appear as a column full of nested tables. Just hit the button at the top right of your new column (it looks like two arrows pointing away from each other) and PQ will give you a pick-list of which columns you want to expand from the merged table.
Pete