Generate Rows

[Ivanmt01]

Hi,

How can I do to generate cells based on the number of the Columns field?
in other words, if the Colums field has a value of 3, 3 lines are created, if it has 0.0

Field_11 column
191-01-77441 1
192-82-04066 4
204-71-37125 4
186-01-58638 2
102-82-00168 0
407-86-09872 4
117-86-38534 3
814-81-61910 9
174-06-37093 3
118-81-03897 2
116-85-36080 1
111-81-41019 6
119-81-52311 2
119-81-77493 2
123-43-92508 15

[estherb47]

Hi,

I’d start by creating a new field with a value of zero. Loop should be
[newfield]+1, and the condition should be [newfield]>[column]

Hoping my logic is correct. I’m not on my computer at the moment.

Let me know if that helps.

Cheers!
Esther
--
Esther Bezborodko
*Senior Manager*
201.650.7314 | estherbezborodko@gmail.com
beautycounter.com/estherbezborodko

*Our mission is to get safe products in the hands of everyone.*
[image: Facebook]

[Dynamomo · Accepted solution]

@Ivanmt01 

If the number determines the number of new rows created, here is a solution using the generate rows

The generate rows creates the new rows, a union is used to bring in the original data, formula tools are used to ID original records from new records.

Let me know if you have questions.