Lookup and Append Columns

Hi All,

May i know how to do vlookup in knime and append additional columns for the output ?

Input Table:
image

Lookup Table:

Output Table (Append column-GL Acc & Amount):

Thanks in advance!!

Hi @mmngeoh

The Joiner node is the equivalent of the vlookup in KNIME.
To use it: select the columns from the input and lookup table that should be used to compare the two. Next, select the type of join you would like to use (inner, left outer, anti, etc.)

Under the Column Selection tab, select which columns you want to use from both tables. In your case you want the GL Account and AMount from the right table.

This will generate the desired output:

Hope this helps!

5 Likes

Hi @ArjenEX , This helps thanks :blush::blush:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.