Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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