Iterate on line (number of iteration depending on filed value)

[hubertderavel]

Dear community

My data set looks like:

Store	Incident	Loop_NB
Store1	IncidentA	3
Store1	IncidentB	2
Store2	IncidentC	3

And I want to loop on the table, depending on the Loop_NB field. Loop_Nb = number of loop to create repeating the data in each line.

Result would look like

Store	Incident	Loop_NB
Store1	IncidentA	3
Store1	IncidentA	3
Store1	IncidentA	3
Store1	IncidentB	2
Store1	IncidentB	2
Store2	IncidentC	3
Store2	IncidentC	3
Store2	IncidentC	3

Thanks for your help.

I hope I at least teased your mind here :)

[jdunkerley79 · Accepted solution]

Use the generate rows tool.

That is exactly what it is for. sample attached

[danrh]

Something like the attached?

[ponraj]

Here is the sample workflow for your case. Hope this is helpful. 

workflowResults

[hubertderavel]

Thanks for your help on this!