Workflow suggestion

[Bbadef]

Hello everyone,

I am using Alteryx to produce two piviot table A and B 

table A

Label	Sum_Original Face
ASSDD	750
FGGG	500

table B

Label	Sum_Par Amount
ASSDD	750
FGGG	500

I am using join tool (join by specific field) 

and then union it (left+ right+ join)( Auto config by name) cause it's possible I found ASSDD in table A but not B, I would like to see the empty cell .

What I expect is

Label	Sum_Original Face	Sum_Par Amount
ASSDD	750	750
FGGG	500	500

What I now have is

Label	Sum_Original Face	Right_Label	Sum_Par Amount
ASSDD	750	ASSDD	750
FGGG	500	FGGG	500

Any help or suggestion with that I will be appreciated it!

Hope you have a good one!

[mceleavey · Accepted solution]

Hi @Bbadef ,

This is simply due to two fields being named the same when you join the two inputs. This will always be the case on the fields you are using to join:

Simply drop the right_ field, as this is identical to the left input as it is your key field.

Hope this helps,

M.

[Bbadef]

Hi @mceleavey ,

Thank you for your help!

[mceleavey]