Keep Specific Rows Only

[faresghnaim]

Hello,

I have created a flag to select the start of the rows I want and the end as seen in the picture below in the "Columns" Column

tI would like to only keep row containing 1 and row containing 2 and anything between these 2 rows.

How could I approach that?

Thanks!

[RolandSchubert · Accepted solution]

Hi @faresghnaim ,

you could use a Multi-Row Formula tool to set a flag. Calculate a flag field starting with the "1", use the last rows value until last row contains the "2". 

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland