I am facing the below issue My Source A IDNAME1Jose2Anna My Source B IDNAME1Jose4Roy After outer join using Alteryx , I get the below results. IDNAMERight_IDRight_Name1Jose1Jose2Annanullnull4Joynullnull But my expected output is as below, as I want to know which record is missing from which side . IDNAMERight_IDRight_Name1Jose1Jose2Annanullnullnullnull4Roy Is there any way? Attaching my workflow Outer_Join_Issue.yxmd

Outer Join Issue

I am facing the below issue

My Source A

My Source B

After outer join using Alteryx , I get the below results.

But my expected output is as below, as I want to know which record is missing from which side .

Is there any way? Attaching my workflow

Join

You just have to change the config on the Union tool. Select the option to manually move the columns and it will give you what you are looking for.

Pedro.

Thanks

You just have to change the config on the Union tool. Select the option to manually move the columns and it will give you what you are looking for.

Pedro.

Thanks