Generate rows

[Thumtum]

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

[AkimasaKajitani · Accepted 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.

[Tyro_abc · Accepted solution]

Hi @Thumtum 

Are you looking for this

[Thumtum]

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