How to add multiple whitespace based on another column

Hello everyone in Alteryx Community,

I wanted to add multiple whitespace based on another column so I can use text to column on the next step.

The given Input and the Required Output are given below.

The formula which I tried to use is given below.

I would really appreciate it if this could be done in a easy and simple to implement way.

Thanks in Advance for the help.

Input And Required OutputTried this but got error

Workflow

Accepted answers

@mrai02
If YES, we can use the Generate Rows tool to generate the necessary number of Space, then put back to the original string.

Another option to do this, you can use the PADLEFT function

@mrai02
So you want to add the the number of "Lvl Number" while space in front of the string?

@mrai02
If YES, we can use the Generate Rows tool to generate the necessary number of Space, then put back to the original string.

Another option to do this, you can use the PADLEFT function

@Felipe_Ribeir0
I feel ashamed now. 😂

😂This function is not very common i guess, i had the lucky to get some practice with it some months ago!

Thanks @Qiu For the solution, it solves the problem but is very long and adds extra steps to the process.

@mrai02
Yes, I also agree. 😁

Hey @Felipe_Ribeir0 , Thanks for solution and showing us a new formula.