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

Generate_Rows.yxdb

AkimasaKajitani

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.

GenerateRowSample_AK.yxzp