Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

How to batch add Superscript in row?

Jo_Dzhou
5 - Atom

How to batch add Superscript in row in Alteryx?

4 REPLIES 4
CharlieS
17 - Castor
17 - Castor

Hi @Jo_Dzhou 

 

Could you share more information on what you're trying to achieve? Tell us about the application, maybe share images of what you'd like to achieve and I'm sure the Community will be able to chime in. 

Jo_Dzhou
5 - Atom

Hi Charlie S,

 

Please attached sample. There will be multiple lines of names which need to add the superscript. So I am trying if the superscript can be added by Alteryx automatically

CharlieS
17 - Castor
17 - Castor

So you've probably figured out that super/sub script isn't natively supported, but we can make it happen. 

 

Conveniently, the example you shared shows the super script appearing at the end of the strings. The idea here is that you compose two text fields: the regular text, then just the super script text. You can join these two together and adjust the vertical position to make it "super" (I also recommend making the super scipt text a smaller font). 

 

20210319-SuperScript1.JPG

 

It's not ideal, but it should work for this application. Check out the attached workflow for an example. 

Jo_Dzhou
5 - Atom

thanks Charlie, saw you have made this in PDF, but I need this in Excel format. However in Excel, they are in two different column, can we put them together?

 

Labels
Top Solution Authors