if blank + vlookup

[Darius]

Hi i am very new to KNIME,

could you please help with this:

So i have a column with some values,
say column Z and some columns are blank I would like to use IF “Z” BLANK, then
vlookup from other table.

In the 2nd table i have a column XY that is the same in the table 2 and table 1 and column Z.

TABLE 1
Column Z Column XY
234______________1
2342_____________2
–MISSING-- ______ 3
34_______________ 4
4________________ 5

TABLE 2
Column Z Column XY
234______________1
2342_____________2
555555___________3
34_______________4
4_______________ 5

I want to get the value of 55555 in Table 1

[julian.bunzel]

Hey @Darius,

you could use the Cell Replacer node for the vlookup. However it will replace every value. To check for the missing value, you could use the Row Splitter to split the table into two tables (one with missing value rows and one with all the other rows) and then use the Cell Replacer node to replace the values in the table with the missing values. Afterwards, you could use the Concatenate node combine these tables again.

Best,

Julian

[ipazin]

Hello @Darius,

you can also use Cell Replacer to add new column in Table 1 with XY values from Table 2. Then use Column Merger node to merge those two columns appropriately. This way you’ll retain row order if necessary.

Welcome to KNIME Commmunity!

Br,
Ivan