Hello everybody In this example I want the columns with missing values not to get skipped. Although there is no value in the columns I want to show the columns in the end. I have tried the missing value operator, but when I put it after the Excel Reader there are already no missing values in the table anymore. Is there any possibility to adapt the “more options” and to get rid off the cross at “skip empty cokumns” (see photo attached) Thanks in advance and have a nice day [image]

Hi there @Schimmel004 , this was an issue in KNIME version 4.0.0. and was fixed with version 4.0.1. See here: [image] XLS Reader More options do not work KNIME Analytics Platform Hello everyone, I experience a bug with XLS Reader, the more options part is in Grey and cannot be edited, I wanted to uncheck the preview because the node gets completely stuck with just showing the preview every time, and it looks like the attached screenshot… [Capture] My KNIME version is 4.0.0 and all the extensions are updated!! Thank you for your help. Solution would be to update your KNIME :wink: Br, Ivan

Missing values in Excel Reader

KNIME Analytics Platform

ipazin February 4, 2020, 10:48am 3

Hi there @Schimmel004,

this was an issue in KNIME version 4.0.0. and was fixed with version 4.0.1. See here:

Solution would be to update your KNIME

Br,
Ivan

4 Likes