ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
GELÖST

Converting a number range into individual numbers

CodyD
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 ANTWORTEN 4
mborriero
Bolide

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

 

See the file attached.

CodyD
Atom

Perfect!  Thank you!

CodyD
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
Bolide

I have converted the string into number. try now.

Beschriftungen
Top-Lösungs-Autoren