Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multiple columns with the same name

BradBaker
7 - Meteor

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.

4 REPLIES 4
Thableaus
17 - Castor
17 - Castor

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,

BradBaker
7 - Meteor

Thanks @Thableaus .  I will try that.

CharlieS
17 - Castor
17 - Castor

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

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

Labels
Top Solution Authors