Is there a more automated method in alteryx to assign values to a category besides a massive "If then" formula? I'm trying to do something similar to what you would do in excel when you use v lookup to assign to categories based on number....like this:
| Lower bound of values | Group Name |
| 0 | 0 - 1.99 |
| 2 | 2 - 3.99 |
| 4 | 4 + |
In excel you would just take your value (let's use 2.5 as an example) and if you reference the table w/ a v lookup it would return the group name on the right. it's dynamic so you can change the bounds and then have this re-process. So 2.5 here would return the "2 - 3.99" group.
I know I could just build a long if statement but we're talking 40+ groups potentially and I'd like to be able to change this in a more structured way, is there any way of doing that?
