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.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels