community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Repeating a text string based on numeric input

Atom

Say I have some data representing the number of A grades a student achieved at A Level like so:

StudentNumber of A grades
13
22
30

 

For the purposes of analysis, I need to turn this data into a string, like so:

 

StudentA Level Band
1AAA
2AA
3 

 

In Excel, this is achievable using the =REPT() Function, which repeats a specified text string a number of times based on a numeric input. Is this possible in Alteryx?

Quasar

Would this work for you?

 

padright string.png

Quasar

Here is the sample workflow for your case.  Hope this is helpful. 

 

workflow.PNGWorkflowResults.PNGResults

Labels