ID Groups of Rows with Data

Hello,

I have a dataset with sporadic events of clustered values. I want to remove the rows with values less than 1 (which seems straight foward), then sequentially ID the events seperated by the dead space.

image

Thanks!

You can do it like this:

young.transform (4.9 KB)

Perhaps someone can come up with a simpler way?

Hi,

A little simpler solution

image

Transform File
youngSimpleSolution.transform (3.5 KB)

1 Like