Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
133
Views
Topic starter
Hi everyone,
I am working with PowerQuery and face an issue. I have 2 tables:
Table 1 content:
| Code | Des | Price |
| A | Banh xe | 5,000 |
| B | Oc vit | 2,500 |
| C | Kim | 6,000 |
Table 2 content:
| Code | Des | Price |
| A | Banh xe | 6,700 |
| C | Kim | 3,000 |
| E | Day | 10,000 |
I want to combine these tables into one with desired content as follow:
| Code | Des | Price 1 | Price 2 |
| A | Banh xe | 5,000 | 6,700 |
| B | Oc vit | 2,500 | - |
| C | Kim | 6,000 | 3,000 |
| E | Day | - | 10,000 |
I cannot find the way :(.
Please help me, thank you very much!
Posted : 28/05/2020 11:05 pm
Hi Viet,
You can merge the tables with a full outer join. See attached.
Mynda
Posted : 29/05/2020 2:14 am
Topic starter
Hi Mynda Treacy,
Thank you very much ^^. Your instruction is great! That's is exactly what I am looking for.
Posted : 29/05/2020 5:40 am
