How create the missing consecutive number in a list

KarenHM

Hi Team,

How create the missing consecutive number or numers in a list.

example:

Consecutive

2340

2341

2342

*2346

2347

2348

2349

2350

Thanks

Datasets

Developer Tools

Tips and Tricks

Accepted answers

ShankerV

Hi @KarenHM

Here is the final step.

Which gives you the missing numbers.

Join tool

Add browse tool to the R node, which will help to filter the missing numbers in the list.

Many thanks

Shanker V

All comments

ShankerV

Hi @KarenHM

Please find the expected output.

Many thanks

Shanker V

ShankerV

Hi @KarenHM

Step 1: Input

Step 2: Summarize

Step 3 :

Many thanks

Shanker V

ShankerV

Hi @KarenHM

Step 4: Select tool

Hope it helps!!!

Many thanks

Shanker V

FinnCharlton

Hi @KarenHM ,

Here is one way to do this:

Consecutive Numbers.yxmd

ShankerV

Hi @KarenHM

Here is the final step.

Which gives you the missing numbers.

Join tool

Add browse tool to the R node, which will help to filter the missing numbers in the list.

Many thanks

Shanker V

KarenHM

@ShankerV Many thanks your solution is perfect !

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335