Table Header Format

[clarrock]

Hi,

I have a table tool for 3 age columns and a name. Because there are multiple 'Age' column names alteryx auto changes the headers to Age1 Age2 and Age - these are numeric fields. How do ensure that my table just has a header age?

Name	01-01-2021	Age1	02-01-2021	Age2	12-01-2021	Age
Abc	23,567.00	3, 000	33,000.00	3,001	24,000.00	0

How do I make the first row of my basic table to just have 'Age' not Age1 and Age2? 

[Emil_Kos]

Hi,

In this topic you have 2 specific workarounds for this problem:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multiple-columns-with-the-same-name/m-...

One of them would be Having Age column with spaces. Like "Age", "Age " and "Age  "

Second would be a table tool. There is a workflow attached to this post that will guide you on how to do it:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multiple-columns-with-the-same-name/m-...

Just to make it more clear you can rename column directly in the table tool.

[clarrock]

@Emil_Kos Thanks, however can't rename every field as they are aged daily (adding a new column). Is there a way in the table tool to add a formula for the header row to just rename to "Age" or can I push these headers to the first row, remove the headers for the table and rename field names as Age, however the problem with the later is that I have to place a data type as string and not double for numeric fields.

[Qiu]

@clarrock 

If you are outputting the data as Excel File, we can choose the option "Skip Field Names".