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

Converting a number range into individual numbers

CodyD
5 - Atom

Hi,

 

I am newer to Alteryx and I need help converting a number range into individual numbers.  For example in my excel I have a low column and to the right I have a high column :

 

90000 - 99999

 

When I run my workflow I need my output to display all numbers in that range.  For example:

 

90000

90001

90002

90003 and so on

4 REPLIES 4
mborriero
11 - Bolide

Hi @CodyD, I would use a Generate Rows tool.

 

See the file attached.

CodyD
5 - Atom

Perfect!  Thank you!

CodyD
5 - Atom

@mborriero

 When I input my data set to the work flow it doesn't work out.  I have attached my excel below.  Let me know if you have an easy fix.  Thank you!

mborriero
11 - Bolide

I have converted the string into number. try now.

Labels
Top Solution Authors