There is a new KNIME forum. You can still browse and read content from our old forum but if you want to create new posts or join ongoing discussions, please visit our new KNIME forum: https://forum.knime.com

Delete column with one specific value

Member for

2 years 5 months SimonSays

Hi there,

I would like to delete a column if it contains the value "-". If there is another value in this column which is not "-" it should not be deleted.

Is there a node to solve this? 

Thanks in advance,

Simon

Comments
Thu, 03/01/2018 - 02:01

Member for

3 years 2 months

agaunt

Hi Simon,

you can delete the value "-" in your column with the String Manipulation Node:

toNull(removeChars($Your_column$, "-"))

Then you can use the Missing Value Column Filter, setting the Missing value threshold to 100%.

Fri, 03/02/2018 - 10:12

Member for

2 years 5 months

SimonSays

Hi Agaunt,

thanks for your help.