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
Solved! Go to Solution.
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
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |