Hi @Joel_P -
Sorry for the delayed response. This problem is a bit more complicated than it seems at first. I think you were on the right track with your idea about transforming your second table into a set of rules - here’s how I implemented that.
RuleEngineLookupExample.knwf (15.7 KB)
There’s a bit of join syntax to deal with in the String Manipulation node that defines the rules. Take a look inside the configurations of each node to see the approach in more detail.
I hope this helps!