Concat on empty rows

[Asimkz]

I’m trying to concat 3 columns together to get a unique identified.
column(“product_code”) + ‘’ + column(“product_sub_code”) + '’ + column(“form_code”) + '’ + column(“container_code”)
The issue is product sub code is not always populated so i get a value like this - productcode _ formcode_containercode. Is there way I can ignore blank rows when the product subcode isn’t populated and get a clean productcode_formcode_container?

[rfeigel]

If you’re getting true missing values, i.e. “?” have you tried the Missing Value node?

[Asimkz]

Values coming out of the DB are blank rows. Attached is a sample workflow,
my concat formula is column(“product code”) + ‘’ + column(“subcode”) + '’ + column(“form”) + '’ + column(“container”) which gives me 1111 _ PL_X1 when subcode is empty but I would like to ignore the empty and just output 1111_PL_X1 without _ _ .
KNIME_project2.knwf (9.1 KB)

[rfeigel]

See if this does what you want.
Append w Empty Rows Skipped.knwf (85.2 KB)

Here’s a way to do it without using the Missing Value node. Your choice.
Append w Empty Rows Skipped 1.knwf (89.1 KB)

[Asimkz]

Thank you so much. That works like a charm!

[prashant7526]

Please mark the post as a solution.

[rfeigel]

Glad I could help you.