How to assign group name to range of non-numeric values??

Question

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?

Data Set #1

GroupFromToA Thru LA*L*Halperin Thru GeorgeHalperinGeorgeA OnlyA*

Data Set #2

First NameLast NamePatrickAndersonTylerBruceAlbertFeltsEmmaHaloSarahHalperinFreddyGeorgeAnneJacksonTerryMyersBrandonTaylor

Resulting Data Set

GroupFirst NameLast NameA Thru LPatrickAndersonA Thru LTylerBruceA Thru LAlbertFeltsA Thru LEmmaHaloA Thru LSarahHalperinA Thru LFreddyGeorgeA Thru LAnneJacksonHalperin Thru GeorgeSarahHalperinHalperin Thru GeorgeFreddyGeorgeA OnlyPatrickAnderson

JohnJPS · Accepted Answer

Hi @thepekingduk

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:

Hope it helps either way!

- John