We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

find sequence from number ranges

tanvir_khan
8 - Asteroid

Hi all:

 

I need to find sequential number ranges. Can anyone please help me in this regard?

I need to capture sequences even if one or two are missing in between.

Thanks in advance.

 

Input

56443733

56443734

56443735

56472189

56477543

56483250

56483251

56483253

88535740

 

Output

56443733

56443734

56443735

56483250

56483251

56483253

 

thanks

2 REPLIES 2
geraldo
13 - Pulsar

@tanvir_khan 

 

An workflow example 

tanvir_khan
8 - Asteroid

many thanks @geraldo 

Labels