Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

create number ranges using workflow

tanvir_khan
8 - Asteroid

Hi all:

 

I've a large number of number ranges in excel file like 100010-100099, 523012-523099, 600888-600999 etc.

I need to create ranges and output those in a single field for example:

Serial

100010

100011

100012

.

.

100099

523012

523013

523014

.

.

523099

6000888

6000889

.

.

600999

Can anyone help me in this regards please?

 

thanks!

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@tanvir_khan 
Maybe we can use the Generate Rows tool?

0307-tanvir_khan.PNG

tanvir_khan
8 - Asteroid

@QiuYou are a Legend!

Qiu
21 - Polaris
21 - Polaris

@tanvir_khan 
Thank you for the kind words also. 😁

Labels
Top Solution Authors