Join 2 table with same colunm name

Question

Hello ,

I have 2 tables

DataitempositionValuepositionJan-202210A50RFeb-202220A50Rmar-202220A30GApr-202230G10A

DataitempositionValuepositionJan-202220A10AFeb-202230G20Amar-202210A10AApr-202210A10A

and merge to one table as below

DataitempositionValuepositionitempositionValuepositionJan-202210A50R20A10AFeb-202220A50R30G20Amar-202220A30G10A10AApr-202230G10A10A10A

merge two table and remaining columns are identical

binu_acs · Answer

@adarsh2608 one way of getting the same column name after joining the data

Same_Column_Name_11_07.yxmd

nlundgren · Answer

@adarsh2608 - following the other notes above, some of the following field names could work:

"item" and "item2"

"item" and "item "

"item" and "item_new"

etc.

The reason being is because Alteryx performs data functions, formulas, etc. on column names (i.e. "Item") vs. column location (i.e. column B)  as excel does. So each column or field of data needs a unique name so Alteryx knows where your data transformation is taking place.

Emmanuel_G · Answer

Hi @adarsh2608 ,

As said before, you cannot have two columns with the same name so Alteryx will add a 2 suffix when a second occurrence of a field name that already exists is present. It will increment step by step with 3,4,5... if more columns are added.

For the join, since there are columns with the same name on both tables, it precedes the column names coming from table 2 with a "Right_".

Otherwise for the display of several fields with the same name (imagining that this is what you want), you can precede or suffix your column names with spaces.

Here is a solution attached which gives the expected result.

Let us know if it works.

Join tables.yxmd