Say I have some data representing the number of A grades a student achieved at A Level like so:
Student | Number of A grades |
1 | 3 |
2 | 2 |
3 | 0 |
For the purposes of analysis, I need to turn this data into a string, like so:
Student | A Level Band |
1 | AAA |
2 | AA |
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?
Solved! Go to Solution.
Would this work for you?
And for those here looking to do this with strings of more than a single character, modify @DavidP's response with a REPLACE function.
Replace(PadRight('',3,'.'),'.','TEXT') would result in TEXTTEXTTEXT.
Used this today - thank you @DavidP