Outer Join Issue

[vdataqlalt]

I am facing the below issue 

My Source A

ID	NAME
1	Jose
2	Anna

My Source B

ID	NAME
1	Jose
4	Roy

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

ID	NAME	Right_ID	Right_Name
1	Jose	1	Jose
2	Anna	null	null
4	Joy	null	null

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

ID	NAME	Right_ID	Right_Name
1	Jose	1	Jose
2	Anna	null	null
null	null	4	Roy

Is there any way? Attaching my workflow

[pedrodrfaria · Accepted solution]

Hi @vdataqlalt 

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.

[vdataqlalt · Accepted solution]

Thanks 

[pedrodrfaria]

Hi @vdataqlalt, please do not forget to assign it as the solution for the post.

Thanks

Pedro.