“Missing Value” node has a bug? or something wrong? Developers please see below. Should I make a new topic? I am attaching a screenshot of the previous workflow. Workflow is under loop to process all columns. Some columns are strings and some integers or doubles. Whenever I try to change the configuration of the “Missing Value” node there is a different option. I need all options! Is that possible to change it? Consequently, I am forced to have one or another (setting for string or double) depending which column will loop first. I found a work around by setting workflow to process string first and change the setting for strings in the “Missing Value” node, and then repeat the same process for double first. Then I do run the workflow and loop for all columns that include strings and doubles. But, this is hard. Could developers please revise the “Missing Value” node? Thank you. [image]

Hi there @amars , created a new topic for this. Missing Values node present only column types available from previous node. Will check it more and get back to you. EDIT: Ticket created to improve handling in such cases. (internal reference: AP-13903) Br, Ivan

One way could be to configure the missing value setting with all the columns present. Save that as a PMML file and then when it comes to the point in the loop where you will either have a string or a column due to looping thru one column at a time only you can import the PMML settings. I will try and see if I can include that with the workflow from the other thread.

[image] mlauber71: I will try and see if I can include that with the workflow from the other thread. Here you go: [image] Exclude missing values from the end of a dataset KNIME Analytics Platform OK here comes the latest instalment. It should handle: column names with brackets it uses @HansS idea of column list loop start (much more comfortable) stores the Missing value rules in (non-standard) PMML and applies them to strings and numbers uses first the following value then the previous one if there are still missings in the non-empty lines Please check if everything works and check if the order of Previous and Following is the one you want (otherwise switch the order). [image] Excl…

Missing Values Configuration

KNIME Analytics Platform

mlauber71 March 14, 2020, 5:37pm 4

Here you go: