Hi everyone, Hoping this is a simple question since I'm fairly new Suppose I have two tables: IDMetric1Metric215321063159 IDMetric 3Metric 4347481451221 I want to Join them to get the following output: IDMetric 1Metric 2Metric 3Metric 4153002106003159474008145001221 Again, it feels like I'm missing something obvious here (I hope). Thanks for the help!

Outer Join with Blanks

Hi everyone,

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

Suppose I have two tables:

I want to Join them to get the following output:

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

Thanks for the help!

Join

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,

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,

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

@Avinash_K I always forget that this tool exists.

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