Merge multiple tables with same columns

[dreldrel]

Hi there, 

I'd like to merge multiple tables together like below. I tried to use the "join multiple" tool but the result is not what I except. Does anyone how to achieve it? Many thanks

Table 1

Join ID-1	Join ID-2	Value
1	a	1
1	b	2
2	b	3
2	c	4
3	a	5
5	a	6

Table 2

Join ID-1	Join ID-2	Value 2
1	a	1
2	b	2
3	b	3
5	a	4

Table 3

Join ID-1	Join ID-2	Value 3
1	a	1
5	c	4

Desired Result

Join ID-1	Join ID-2	Value	Value 2	Value 3
1	a	1	1	1
1	b	2	null	null
2	b	3	2	null
2	c	4	null	null
3	a	5	null	null
3	b	null	3	null
5	a	6	4	null
5	c	null	null	4

[MilindG · Accepted solution]

Okay, check out the workflow and see if it works for you.

[BRRLL99]

Hi 

Use Union Tool

[grazitti_sapna · Accepted solution]

@dreldrel Please use the below workflow for your problem.

[dreldrel]

Hi guys, many thanks for quickly getting back to me with all solutions! I chose @MilindG ones as I have to merge many tables.

[Emmanuel_G · Accepted solution]

@dreldrel 

One way of doing this.

Please do not hesitate to mark this answer as solution if it helped.