fillernode properties

Last updated: Jan 18, 2024

Filler node icon 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\"")

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.
`condition`	string
`replace_with`	string