The Filler node replaces field values and changes storage. You can choose to
replace values based on a CLEM condition, such as @BLANK(@FIELD). Alternatively,
you can choose to replace all blanks or null values with a specific value. A Filler node is often
used together with a Type node to replace missing values.
Example
node = stream.create("filler", "My node")
node.setPropertyValue("fields", ["Age"])
node.setPropertyValue("replace_mode", "Always")
node.setPropertyValue("condition", "(\"Age\" > 60) and (\"Sex\" = \"M\"")
node.setPropertyValue("replace_with", "\"old man\"")
Copy to clipboardCopied to clipboard
Table 1. fillernode properties
fillernode properties
Data type
Property description
fields
list
Fields from the dataset whose values will be examined and replaced.
replace_mode
Always Conditional Blank Null BlankAndNull
You can replace all values, blank values, or null values, or replace based on a specified
condition.
About cookies on this siteOur websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising.For more information, please review your cookie preferences options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.