This node allows you to fill in missing data contained in the input data. You replace the ? value with a supplied value or on the Min,Max or Average value of valid data in the specified columns.
- Output Data Columns section allows you to analyse what input data columns are incomming into the node.
- Filler Type section determines how individual columns missing data are filled in. First select the column you wish to change the missing value for (ie: ?).
- None allows you to ignore the column where the missing values will not be replaced. This is the default action.
- Min allows you to replace all the missing values with the minimum value of the data contained within the whole column that is not missing.
- Max allows you to replace all the missing values with the maximum value of the data contained within the whole column that is not missing.
- Average allows you to replace all the missing values with the average value of the data contained within the whole column that is not missing.
- User allows you to replace all the missing values with the user supplied value. If the column type is Continuous then the supplied user value is converted to a numeric.
NOTE: Global Constants can be used within the User entry.