How to add multiple whitespace based on another column

[mrai02]

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

[Qiu]

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

[Qiu · Accepted solution]

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

[Felipe_Ribeir0 · Accepted solution]

Hi @mrai02 

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

[Qiu]

@Felipe_Ribeir0 
I feel ashamed now. 😂

[Felipe_Ribeir0]

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

[mrai02]

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

[Qiu]

@mrai02 
Yes, I also agree. 😁

[mrai02]

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