Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How create the missing consecutive number in a list

KarenHM
7 - Meteor

Hi Team,

 

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

 

example:

 

Consecutive

 

2340

2341

2342

*2346

2347

2348

2349

2350

 

Thanks 

6 REPLIES 6
ShankerV
17 - Castor

Hi @KarenHM 

 

Please find the expected output.

 

ShankerV_0-1675088901535.png

 

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @KarenHM 

 

Step 1: Input

ShankerV_0-1675088940872.png

Step 2: Summarize

ShankerV_1-1675088962553.png

ShankerV_2-1675088974640.png

 

Step 3 : 

ShankerV_3-1675088991780.png

 

ShankerV_4-1675089010022.png

 

Many thanks

Shanker V

 

 

ShankerV
17 - Castor

Hi @KarenHM 

 

Step 4: Select tool

 

ShankerV_0-1675089064371.png

 

ShankerV_1-1675089072436.png

 

 

Hope it helps!!!

 

Many thanks

Shanker V

FinnCharlton
13 - Pulsar

Hi @KarenHM ,

Here is one way to do this:

FinnCharlton_0-1675089115662.png

 

ShankerV
17 - Castor

Hi @KarenHM 

 

Here is the final step.

 

Which gives you the missing numbers.

 

ShankerV_0-1675089190877.png

 

Join tool

ShankerV_0-1675089251569.png

 

 

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

 

ShankerV_1-1675089292797.png

 

Many thanks

Shanker V

 

 

 

KarenHM
7 - Meteor

@ShankerV  Many thanks your solution is perfect !

Labels
Top Solution Authors