Create a new table from multiple tables

[luisseneto]

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?

[themistoklis]

@luisseneto

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]  ), 			  
			  )

[luisseneto]

Thank you @themistoklis !!

[mwegener · Accepted solution]

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 )

[luisseneto]

Thank you @mwegener !!

[mwegener]

You are welcome