Forum Discussion
Solved
Create a new table from multiple tables
Hi,
I'm trying to joining multiple tables and i dont know how to do it.
Table 1:
| id | name | value |
| 1 | aaa | 123 |
| 2 | bbb | 234 |
| 3 | ccc | 345 |
Table 2:
| id | name | value |
| 1 | aaa | 432 |
| 2 | bbb | 543 |
| 4 | ddd | 154 |
| 5 | eee | 346 |
| 6 | fff | 908 |
Expected result:
| id | name | Table1.value | Table2.value |
| 1 | aaa | 123 | 432 |
| 2 | bbb | 234 | 543 |
| 4 | ddd | null | 154 |
| 5 | eee | null | 346 |
| 3 | ccc | 345 | null |
| 6 | fff | null | 908 |
I tried to append, merge this queries using FULLOUTERJOIN, however i wasnt successfull.
Someone please can help me?
Hi luisseneto,
1. rename the value columns (Table1.value, Table2.Value)
2. Append Table1 & Table2
3. Group by id, name (Sum Table1.Value, Table2.Value )
5 Replies
Hi luisseneto,
1. rename the value columns (Table1.value, Table2.Value)
2. Append Table1 & Table2
3. Group by id, name (Sum Table1.Value, Table2.Value )
Thank you mwegener !!
You are welcome
Create a new table and add the following formula:
Table = UNION(SELECTCOLUMNS(Table1,"ID", Table1[id],"Name", Table1[name],"Value1", Table1[value],"Value2", "" ), SELECTCOLUMNS(Table2,"ID", Table2[id],"Name", Table2[name],"Value1", "","Value2", Table2[value] ), )Thank you themistoklis !!
