Depetite rows according to the value of the quantity column

[Gfranco2021]

Hello, I need to replicate the number of rows based on the value of the quantity column. Example.

thank you.

[gonhaddock]

Hello @Gfranco2021
you can achieve the expected result with the following sequence of nodes:

20240618_depetite_rows_according_to_quantity_v0.knwf (11.2 KB)

BR

[Gfranco2021]

Excellent thank you very much,

[gonhaddock]

Hello @Gfranco2021
Just for the records. Alternatively you could use only the ‘One Row to Many’ node straight away; and with the help of some ‘String Manipulation’, you would be able to isolate the target integers from the ‘Row ID’, for the subset counts.

String Manipulation:

toInt(regexReplace($$ROWID$$, ".+(\\d+)", "$1")) - 1

BR

[Gfranco2021]

Excellent thank you very much.