Forum Discussion
Get value from another table
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!
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
3 Replies
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
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