LAG function

kwmcm — Tue, 08 Jan 2019 20:40:10 GMT

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 ) );

Re: LAG function

vince_faller — Tue, 08 Jan 2019 20:48:49 GMT

add | row() == 1

dt << select where( :name( "Run" )[Row()] != Lag( :name( "Run" )[Row()] ) | Row() == 1 );

Re: LAG function

kwmcm — Tue, 08 Jan 2019 20:50:16 GMT

THANK YOU!

topic Re: LAG function in Discussions

LAG function

Re: LAG function

Re: LAG function