Forum Discussion
Combine multipe tables
hi all,
probably one of the most stupid questions :). I have three tables:
Table 1: Region 1
| Sales ID | Region ID |
| S001 | R010 |
| S002 | R011 |
| S003 | R012 |
Table 2: Region 2
| Sales ID | Region ID |
| S001 | R017 |
| S002 | R018 |
| S007 | R019 |
Table 3: Region 3
| Sales ID | Region ID |
| S008 | R020 |
| S001 | R021 |
| S009 | R022 |
I want to add one "total table"
| Sales ID | Region ID |
| S001 | R010 |
| S002 | R011 |
| S003 | R012 |
| S001 | R017 |
| S002 | R018 |
| S007 | R019 |
| S008 | R020 |
| S001 | R021 |
| S009 | R022 |
All tables have 100.000+ rows, but have a unique "Key" (sales ID & region ID).
Many thanks in advance
Regards, Frank
1 Reply
Hello frankhofmans ,
You could acheive this using append queries in Power query.
check this for intrsuctions https://learn.microsoft.com/en-us/power-query/append-queries
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
