Append Column

[dhakim1996]

Hi I would like to append a column from one table to another table. I have used the join function. However, it is only returning those where the condition match. I would like to be where the those no do not match it will return a null value instead of just removing that row. Could anyone assist please. Thank you!

[grazitti_sapna]

Hello @dhakim1996, one way would be using the join multiple tools. This tool returns all the values from both the tables which do not match along with the matched values.

Another way around is using a join tool and if you want to return non-matched values from the left or right data set then use a union tool by unionizing data from the left or right anchor.

I hope this helps!

Thanks!

[Qiu]

@dhakim1996 
Try to to Bring the data stream of from J anchor and L or R anchor back together with an Union tool.