Hi all, a probably rookie question from me.
I have this table where I have two columns - Start and End. I need to generate rows for the text strings between the Start and End columns. For example, in the first line I have 0101 in the Start column, and 0106 in the End column. I need to generate rows so that my output is something like the below:
Is this something you can help me with?
Thank you!
Art
Solved! Go to Solution.
Hi @Thumtum
Here is my solution for you.
It is possible to add a formula tool for a simpler setup, but in this case I used only the Generator row tool.
Initialization Expression
[Start]
Condition Expression
ToNumber(RowCount) <= ToNumber([End])
Loop Expression
PadLeft(ToString(ToNumber(RowCount) + 1),4,"0")
I convert the newly created field to number type by "ToNumber" and added 1 to it. After that, I padded it with 0 to make the character length 4.
Hi @AkimasaKajitani and @Tyro_abc
This is exactly what I needed! Thank you very much both for your kind help! This will allow me to proceed now.
Thanks,
Thumtum