Checking if value of a row is consecutive

[#1]

Hi JMP Community,

I want to check if the values of a row are consecutive and if it not then get the value of the first row which doesn't satisfy the condition.

For example : In this table, Column 1 has rows 1 to 15 that have consecutive values 1,2,3 and then row 16 has value of 12. So I would like to get the value of that first row that doesn't satisfy the consecutive condition.

Is there a more jsl way than using an iterator? 

Thanks, 
Jackie

[#2 · Accepted solution]

One option would be to use Lag() or Dif() with Get Rows Where()

first_nok = Min(dt << Get Rows Where(Dif(:Column 1) > 1));

[#3]

Awesome! Thanks Jarmo!