VLOOKUP with Wildcard

Yes @Daniel_Weikert , I do use H2 database for the joiners, and I’m a little vague about what constitutes a “large” or “small” data set, but the only optimised joiner I have which works better for larger datasets is the last one I posted the “Join Custom Condition -indexed” component, because I added extra code in that to create indexes in the H2 database for the columns used in the join.

Details on the difference this made can be found here:

2 Likes