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.
Solved! Go to Solution.
@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.
@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.