This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Need help in assigning a group to a set of data using a range of values. The groups and ranges are defined in data set #1. The values (names) are defined in data set #2. How do I have Alteryx evaluate the group ranges, look up the values based on last name in data set #2, and produce the resulting data set below?
Just for clarification, if there is a wildcard, it just returns everything starting with the given characters; but if there is no wildcard, then it needs to return find the row matching the first LastName, and the row matching the second last name, and return all rows in between, regardless of alphabetization? (In the example provided, Halperin is alphabetically before George so an alpha match would never return rows... if we fix it a grab from George to Halperin, we would also get Halo in the result set).
The attached solution works using an alphabetical selection, not using a row-wise approach, which is, I'm hoping, what you're after: