Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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
‎07-25-2017 08:13 AM

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

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

4 REPLIES 4
mborriero
11 - Bolide
‎07-25-2017 08:18 AM

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

 

See the file attached.

CreateNumbers.yxmd
Reply
0 Likes
CodyD
5 - Atom
‎07-25-2017 08:24 AM

Perfect!  Thank you!

Reply
0 Likes
CodyD
5 - Atom
‎07-25-2017 08:37 AM

@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!

150 KB
Reply
0 Likes
mborriero
11 - Bolide
‎07-25-2017 08:48 AM

I have converted the string into number. try now.

CreateNumbers.yxzp
Reply
0 Likes
get your questions about inspire answered by inspire attendees
learn more about the python upgrade coming in may 2024
Labels