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

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
20 - Arcturus
20 - Arcturus

@tanvir_khan 
Maybe we can use the Generate Rows tool?

0307-tanvir_khan.PNG

tanvir_khan
8 - Asteroid

@QiuYou are a Legend!

Qiu
20 - Arcturus
20 - Arcturus

@tanvir_khan 
Thank you for the kind words also. 😁

Labels