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.