to find jumps in list consecutive of numbers

Hey colleages;
I have a list of consecutive numbers but I have to find the jumps of numbers in the list.
How can I do?

Thanks in advance!!

Hello @MoLa_Data
You can create a ‘n-1’ column: with the ‘Moving Aggregation’ node (window length 2… ) plus ‘Math Formula’ node. Then a ‘Rule Engine’ node Boolean to highlight the non consecutive rows.

Let us know if further help is needed :wink: , then provide some example about how your data looks like


This community is awesome :grin:


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.