We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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