Data after Union still shows the heading as "right" even though they have the same name

[CherieACI]

I'm still quite new to Alteryx so I hope this is a simple question! I have common data from the 4th and 5th inputs that I am joining then unionizing but I don't understand why my Right_M3 SFC is not combining with the M3 SFC column. What am I missing? 

[Emil_Kos]

Hi @CherieACI,

This isn't related to the join tool renaming your column name? 

[atcodedog05]

Hi @CherieACI 

Renaming of right_ is usually caused by Join tool. You might want to check join tool output.

[CherieACI]

I'm not sure. I don't know what to do to fix it. 

[atcodedog05]

Hi @CherieACI 

Check embedded select of all the Join tools for renaming issue.

Renaming happens when there is same name in right and left. Best choice unselect the right column to prevent duplicate column.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Emil_Kos]

Hi @CherieACI,

Each join tool can create an additional columns. Please look into the screen below:

In order to remove them please click options and deselect duplicated fields:

In order to get only relevant columns without duplicates:

I have mocked a workflow for you.

[echuong1]

The field is being renamed in the Join tool right before the union. Alteryx acts like a database - you can't have two fields with the same name. It will automatically rename any subsequent instances, thus why the second instance is renamed to "Right_name." 

In your union tool, toggle over to manually configure fields. Use the arrows to manually align the fields. Alternatively, you can have a Select tool right before the Union tool and rename the fields to match.

[Emil_Kos]

Hi @CherieACI ,

@echuong1 made a good point with the union tool and sometimes manually configuring can be really.

In this particular case, I would go look into the join tool itself as this will be easier for you to maintain this workflow in the future. If your file structure would be changed in the future it might brake your workflow and you would need to revisit it if you will configure everything manually. 

Good luck!