Hi All,
I'm hoping this is an easy line of code someone can help me with.
I have a LAG function script written, but it's not letting me grab the first Run.
How can I get it to see that there's a Run 1, and not just skip it?
Attached is the data.
Thanks!
Here's my script:
Names Default To Here( 1 );
dt = Current Data Table();
dt << select where( :name( "Run" )[Row()] != Lag( :name( "Run" )[Row()] ) );
dtNew = dt << subset( selected columns( 0 ), selected rows( 1 ) );