Table Header Format

Question

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?

Name01-01-2021Age102-01-2021Age212-01-2021AgeAbc23,567.003, 00033,000.003,00124,000.000

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

Qiu · Answer

@clarrock

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

0112-porpergrey.yxzp

clarrock · Answer

@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.

Emil_Kos · Answer

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-p/372677/highlight/true#M68536

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-p/372692/highlight/true#M68539

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