Repeating a text string based on numeric input

[Willox]

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?

[DavidP · Accepted solution]

Would this work for you?

[ponraj · Accepted solution]

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

WorkflowResults

[Paul-Evans]

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.

[SeanAdams]

 Used this today - thank you @DavidP