Multiple columns with same header

[henrygeorge]

Hi 

I have multiple columns with the same header ie Age 

My output is in such a way that its Age_1 Age_2.how do not have such an output and change all Age_9,etc to just Age Header

[Assaf_m]

Hi,

You can use the "Select" tool to rename a column but each column should have a unique name.

[fmvizcaino · Accepted solution]

Hi @henrygeorge ,

See attached workflow to see how that can be done.

The idea is to load your file once again and do the process as showed in the example.

Let me know if that works for you.

Best,

Fernando V.

[henrygeorge]

@fmvizcaino the problem with this is that the input and output has a row with F1, F2, etc. I just want my existing columns to change to Age without the unique ID Age eg Age_2. Please help 

[fmvizcaino]

Hi @henrygeorge ,

If your output is an excel file, you can do as I have shown you. The output data tool has a configuration to skip field names so your F1,F2 will be skipped and the column name will be Age for all.

Alteryx doesn't accept identical column names and automatically rename as you have seen. The solution I provided is for excel only.

Best,

Fernando Vizcaino