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