Avoiding renaming of column with same name in output

Hasanparvez

In Alteryx, I want to write an Excel output that contains two columns with the exact same column name. However, Alteryx automatically renames them as ColumnName and ColumnName1. How can I prevent this and keep both columns with the same name in the Excel output?

I know its doesn't  sounds logical to have multiple column with same name. However  that's  the need at the moment.!

EKasminsky

You could add an empty space after one of the column names so they look the same, but are not the same.

You can skip field names in the Output Tool however, and output your data to a sheet with the column names how you want. However, you will need to make sure the column order is exactly how Alteryx is outputting the columns.