Generating Rows.

[danielgrayhobbs]

Hi all, 

I am sure this is very simple for many, but I have not used the generate rows tool before and cant work this out after some searching. 

Based on the "Expected Duration" column.

I would like to add a new row each time the number is greater than 390.

For example with the first row, Faketown, which is 400, I would like a new row to be created with '10' in the "Expected Duration" column for "Site Name" 'Faketown'

Im assuming this is generate rows tool but just cannot work this out.

Thank you.

 

[flying008 · Accepted solution]

Hi, @danielgrayhobbs 

Like this ?

Input
Site Name	Expected Duration
Fast	350
Faketown	400
Fakeville	500
Fakest	450
Output
Site Name	Expected Duration	RowCount
Fast	350	1
Faketown	400	1
Faketown	10	2
Fakeville	500	1
Fakeville	110	2
Fakest	450	1
Fakest	60	2

[danielgrayhobbs]

Hi Flying008.

Yes that is exactly what I am after. Would you care to share a view or the example workflow back so I can see how to achieve this?

Thank you very much. 

[danielgrayhobbs]

Oh sorry. Didnt see the second video. Will try attempt that now. 

Thank you again!

[flying008]

Hi, @danielgrayhobbs 

If help you get your want, please mark it as a solution and give a like for more share.

[danielgrayhobbs]

Thank you for your assistance. 

Is there a way I could edit this to handle say me putting 1500 into the expected duration. 

For example I would like this to break into 4x rows and I think the number 2 highlighted in Generate Rows will always limit this to two rows. 

I really appreciate your help on this. 

[flying008]

Hi, @danielgrayhobbs 

Could you please give a want output data for this case?

[danielgrayhobbs]

Absolutely, Here you are. 

Thank you again. 

[CoG]

Adapting @flying008's excellent solution:

[danielgrayhobbs · Accepted solution]

That is spot on @CoG . Thank you and @flying008 for all your help. This is doing exactly what I needed.!