Start Free Trial

Alteryx Designer Desktop Discussions

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

Determining what range a value in one table fits in based on a second table

Neil-HawaiianAir
7 - Meteor

Hello,

 

I suspect this is some sort of looping workflow but I'm not sure how to set it up.  I have a table with a list of Items and Values.  I want to compare the values in this table to ranges in another table and return the results.  I have attached an Excel file that has the Items in one tab (Items), the Ranges in another (Ranges) and the Results in a third (Results).

 

Any suggestions would be appreciated.

 

Neil

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

Hi @Neil-HawaiianAir 

 

Here's a quick and easy way to do it with a Generate rows tool

 

DavidP_0-1639689908593.png

 

Neil-HawaiianAir
7 - Meteor

Thanks David,

 

I was using the generate row to span the entire value set and joining - which ended up getting rather slow using my full set of data.  I like the idea of generating the rows off the ranges as it limits the dataset.  

 

Regards,

Neil

Labels
Top Solution Authors