Lookup and Append Columns

[mmngeoh]

Hi All,

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

Input Table:

Lookup Table:

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

Thanks in advance!!

[ArjenEX]

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!

[mmngeoh]

Hi @ArjenEX , This helps thanks