Get value from another table

[jacquelineq]

Hi, I would appreciate any help on the following. I have 2 tables as follows:

Table1

ID	Date	Amount
123	1-Jan-01	100
234	7-Jul-02	297

Table2

ID	Description	Category
123	Hello World	Book
234	Sunny Day	E-Book

I would like to populate the 'Description' column in Table2 to Table1. New Table1 will be as follows:

ID	Date	Amount	Description
123	1-Jan-01	100	Hello World
234	7-Jul-02	297	Sunny Day

How do i do that with Power Query Editor? Thanks!

[BA_Pete · Accepted solution]

Hi @jacquelineq ,

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

[jacquelineq]

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.

[BA_Pete]

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