Ask is to compare strings in Table 3 with Strings in Table 1 and 2. If any of the strings from Table 1 and/or 2 matches to Table 3 strings, then create a separate column with matched value from Table 3.
Table- 1
dog
playful cat
fish
funny monkey
Table- 2
Short Tail
long ear
Cat
cute
Table-3
Cat loves dog
Dog is as cute as my cat
Long ear monkey loves playing with fish.
Fishes are cute
dog with short tail goofs around
To Get what you need I’d recommend in Group by use List function instead of Max.
Also take in account that KNIME is case sensitive. Also, if you prefer Index function you may not need Rule Engine Dictionary as I assume expressions like Field LIKE “cat” => “cat”