Outer Join with Blanks

[PaulMRichard]

Hi everyone,

Hoping this is a simple question since I'm fairly new

Suppose I have two tables:

ID	Metric1	Metric2
1	5	3
2	10	6
3	15	9

ID	Metric 3	Metric 4
3	4	7
4	8	14
5	12	21

I want to Join them to get the following output:

ID	Metric 1	Metric 2	Metric 3	Metric 4
1	5	3	0	0
2	10	6	0	0
3	15	9	4	7
4	0	0	8	14
5	0	0	12	21

Again, it feels like I'm missing something obvious here (I hope).

Thanks for the help!

[Thableaus · Accepted solution]

Hi @PaulMRichard

You need to use a Join and Union the L, J and R anchors of the Outputs all together.

In this case, you might also use the Data Cleansing tool to replace Nulls with 0's.

Cheers,

[Avinash_K]

Use the Join Multiple tool along with data cleansing to achieve this

[Thableaus]

@Avinash_K I always forget that this tool exists. 

True. Join Multiple is a way easier solution in this case.

[Avinash_K]

@Thableaus That’s the beauty of Alteryx , so many ways to do one thing ... I have realized that we all tend to have our favorite tools in Alteryx which we use frequently and slowly forget about the vast availability of other tools ;-). visiting the community frequently keeps me aware of some of this less used tools .