I still have challenges with the expression not filtering out empty values. Missing values are filtered. I've checked for spaces, line & carriage returns. Help!
Hey Nick, I've observed that excel writer output makes all format as 'General' if you check it in excel. Just wondering how KNIME change the general format to text format in excel?
Hey Gordon, use a column expressions and say if ( column == 0 ) { “” } or you can also use { missingValue() } if you wan the 0 as an actual missing value
Thank you mate! Another question is how to format a certain column to "Align left" format?
I still have challenges with the expression not filtering out empty values. Missing values are filtered. I've checked for spaces, line & carriage returns. Help!
Hey Nick, I've observed that excel writer output makes all format as 'General' if you check it in excel. Just wondering how KNIME change the general format to text format in excel?
Hello Nick, lets say you have 1 column with 10 rows then in that data there's three "0". So my question is, how can you change that "0" to blank?
Hey Gordon, use a column expressions and say if ( column == 0 ) { “” } or you can also use { missingValue() } if you wan the 0 as an actual missing value
@@nickydee3088 Thanks man!!
How to filter rows more then one condition?
Hey Felipe, use AND or OR operators to string together multiple conditions
@@nickydee3088 Ok thanks