nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

642296_en-US

liliconcom

Checking if value of a row is consecutive

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

Automation and Scripting

Re: Checking if value of a row is consecutive

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

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