Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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