VLookup Cell Replacer 2 columns

KNIME Analytics Platform
1

I want to use two columns for a VLookup and therefore need to transfer iteratively columns from each table to cell replacer. I have to use two Column List Loops coming together at the cell replacer.

Unfortunately, the cell replacer cannot handle two overlapping loops. Message: "Can't merge Flow Variable Stacks. How can I handle that?

2

You need to merge the flow variables by hand with the Merge Flow Variables node.

Mostly this is done automatically, but if you have two loops sometimes this can not be decided.

So, you are coming from an Excel Background :) I had to google the VLookUp.

Cheers, Iris