Combining multiple columns

Hello,

Is there a way to combine multiple column and asking knime to skip any missing values? I’ve tried using the column combiner but it merges the missing values that was noted as “?”.

Have been trying this for a while now so i hope someone can help.

Thanks!

Hello @heywaiming,

and welcome to KNIME Community!

Column Combiner doesn’t have option to skip missing values. Instead use Column Aggregator where you’ll find option to skip missing values. I assume aggregation method you need is Concatenate :wink:

Br,
Ivan

7 Likes

Thanks so much! It worked and I’ve spend so long trying to figure out using column combiner + string manipulation.

Still kind of new at this! Was wondering if there is a list of common function and description that I can refer to?

1 Like

You are welcome @heywaiming.

There is a lot of learning materials around KNIME. Check their learning space:
https://www.knime.com/learning

There you’ll find Cheat Sheets which seems closest to a “list of common functions” you are looking for.

Additionally check this forum topic on learning KNIME were users share their experience:

Br,
Ivan

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.