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?