cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Choose Language Hide Translation Bar
kwmcm
Level III

LAG function

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
vince_faller
Super User (Alumni)

Re: LAG function

add | row() == 1

 

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

View solution in original post

2 REPLIES 2
vince_faller
Super User (Alumni)

Re: LAG function

add | row() == 1

 

dt << select where( :name( "Run" )[Row()] != Lag( :name( "Run" )[Row()] ) | Row() == 1 );
Vince Faller - Predictum
kwmcm
Level III

Re: LAG function

THANK YOU!