String Manipulation with Blank as it is

[uksong]

I have such table and the expected result after the string manipulation is in column 2 (= join(column 0, column 1)

column 0 column 1 column 2
John Hello JohnHello
Tom Hi TomHi
Amy (blank) Amy

But in KNIME, the table shows like this. There is no result for the row with “Amy”.
column 0 column 1 column 2
John Hello JohnHello
Tom Hi TomHi
Amy ? ?

How can I solve this issue?

Thanks.

[izaychik63]

You can use

Missing Value — NodePit

node to replace null string with space.

[armingrudd]

Hi @uksong,

In addition to the solution by @izaychik63, you can also use the Column Expressions and this expression:

join(string(column("column 0")),string(column("column 1")))

This trick does not work in String Manipulation.

[ipazin]

Hi there,

check this topic for more.

Br,
Ivan