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