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

[Neil-HawaiianAir]

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

[DavidP · Accepted solution]

Hi @Neil-HawaiianAir 

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

[Neil-HawaiianAir]

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