CONCATENATE, BLANC IF NO VALUE IN BOTH COLUMNS

Hi

I would like to concatenate 2 columns, cat3/cat4, but if there is no value in the second column (cat4) than I would like to have no value in the added column

I’ve tried the aggregator with string manipulation but I don’t have the result I want.

hi cinthy
i’m using the expression node to implement the following logic:
“If there is no value in the second column (cat4), then I want the added column to have no value.”
image
image

rgds
linux knime 5.1.x

1 Like

Hi,
I’ve tried to use the formula but there seems to be something wrong.
When I evaluate I get an error.

hi Cinthy
please find the attached w/flow for the syntax
KNIME_comb_MM.knwf (78.7 KB)

rgds
linux knime 5.1.x

3 Likes