topic Checking if value of a row is consecutive in Discussions

Checking if value of a row is consecutive

Jackie_ — Wed, 14 Jun 2023 15:27:19 GMT

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

Re: Checking if value of a row is consecutive

jthi — Wed, 14 Jun 2023 15:40:56 GMT

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

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

Re: Checking if value of a row is consecutive

Jackie_ — Wed, 14 Jun 2023 15:46:26 GMT

Awesome! Thanks Jarmo!