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!
Solved! Go to Solution.
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 I always forget that this tool exists.
True. Join Multiple is a way easier solution in this case.
@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 .