In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Create list of numbers between given range

ayadav8
8 - Asteroid

Hi,

 

My given data has an upper range and a lower. I need a list of all numbers falling in between this range. It might be an easy problem but I am finding myself confused. Is there an easy solution to it?

I have attached an example for easy understanding. 

 

Thanks!

3 REPLIES 3
BenMoss
ACE Emeritus
ACE Emeritus

Hi @ayadav8 there is a relatively straight forward solution to this problem which is by using the generate rows tool.

 

I've created some of my own sample data and have attached an example, have a go at implementing this solution with your data and let us know if you have any questions.

 

2019-03-13_12-04-44.png

 

Ben

CharlieS
17 - Castor
17 - Castor

@BenMoss nailed it with the Generate Rows tool. I've attached a workflow that uses that tool for your application. 

ayadav8
8 - Asteroid

@BenMoss , @CharlieS  That was perfect. Thanks!

Labels
Top Solution Authors