I want to return a value from another table (dictionary) using a lookup value but with different format. See example and attachment:
Coco B. Martin 48
I want to return this table 3:
Martin, Coco 48
Main Table.xlsx (9.2 KB)
Dictionary.xlsx (3.9 KB)
you might consider Value Lookup – KNIME Community Hub - you can specify the rule for string matching in the configuration window of this node. This allows for flexibility and does not restrict match to be exact.
Hope it helps!
Maybe you can use the join node for it… the first step you need to set the left columns and the right column to check it… it doesn’t need to have the same name, is that help you?
At this momment, you an set only the match cases or any response you need, and can use the port to split the data as you with (top as match, middle as left only, bottom as right only)
join.knwf (18.8 KB)
May 17, 2023, 2:32am
Forum H2 Join.knwf (156.9 KB)
This is kind of an advanced approach, but it is my preferred method for joins like this.