Value Lookup, loop or other nodes?

Hello KNIMErs,

I’m finalizing my workflow and I feel Value Lookup node should be used. Probably, it should be located inside a loop. However, I can’t build the correct workflow for this. The below example replicates my challenge.

Sample Data Table looks like this:

Sample Dictionary Table looks like this:

Expected Output Table should base on data table, contain extra column and look like this:

Sample workflow looks like this:

Of course, real tables contains more rows, more columns, and there are variety of patterns being used for column names.

How should the sample workflow look like to generate expected output table from input tables?

Happy KNIMEing,

Kaz