Multiple columns with the same name

Question

Is there a way to give the same name to multiple columns?  For instance, I have a total of 1,000,000 in the Total column, then five columns to the right that each have 200,000.  I would like to add 10 columns that are all labeled % of Total.  The Mutli-Field tool allows me to add % of total as a prefix or suffix, but not as a stand alone label.

Columns with the Same Name.yxmd

Thableaus · Accepted Answer

Hi @BradBaker

No, it's not possible. But a Workaround is to add extra whitespaces in each column.

Example: % of Total , % of Total  , % of Total   , % of Total    , % of Total

Cheers,

CharlieS · Accepted Answer

@Thableaus is correct that you cannot have duplicate field names within Designer. However, you can have duplicate field names in a Layout. If you use the Table tool to create a formatted table, you can duplicate field names there. I've added an example of this in the workflow you shared.

BradBaker · Accepted Answer

Thanks @CharlieS .  This is going in a report, so it will work for my purposes.