Group based on contains text in one column field

[robert_derubeis]

Hi,

I have one column (field_1) that I need to be able to group based on a row containing "started running" and ends with containing "finished".

I need to group all the rows- from "start" to "finished" and all rows in between together as one assigned group- (based on the highlighted colors below). I tried using the "Generate Rows" tool, but couldn't get it to work on a string field and a Contains("started running").

Below is an example of the data format, where "text" is just a lot of additional text in my file that is all different.

****************************start******************
field_1
started running.... some additional text text
text, text, text
text text
text
text
text
text
text
text
text
text
text
text
text
Finished in.... added text text
started running.... more text text
text
text
text
text
text
text
text
Finished in.... more text text
started running.... add text text
text
text
text
text
text
Finished in.... some more text text
started running.... text text
text
text
text
text
text
text
Finished in.... text text
****************************end******************

Thanks,
Bob

[binuacs]

@robert_derubeis one way of doing this with the multi-row tool

[abe_ibanez]

Hello, 

Instead of using the generate rows tool, I would recommend using the multi-row tool. 

if Contains([Field1], 'started running') then [Row-1:Group] + 1
else [Row-1:Group] endif

[robert_derubeis]

That's perfect, exactly what I was looking for!  Thank you!