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?
![Jackie__1-1686755738953.png Jackie__1-1686755738953.png](https://community.jmp.com/t5/image/serverpage/image-id/53809i1AC9BDB67724C9B0/image-size/medium?v=v2&px=400)
Thanks,
Jackie