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!
ipazin
December 16, 2022, 7:28am
2
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
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
ipazin
December 16, 2022, 7:42am
4
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:
Hi everyone,
I just started to use knime about 3 months ago. I have already watched the E-Learning course.
But i want to learn more and improve my skill with advanced learning.
Do you know where I can find more free ressources to improve my knowledge ?
Thank you for your help.
Br,
Ivan
2 Likes
system
Closed
December 23, 2022, 7:42am
5
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.