|
|
Replace Node |
The replace node allows you to search and replace values within one or more database fields.
An important use of this node is to handle the representation of missing values. In some cases, missing values are represented by constant values, question marks, and so on. The replace node can remove these placeholders and treat missing values as missing (that is, there is no entry in the database for this position). The value should be entered as either MISSING, Missing or missing and can be used as either the search or the replace token.
You can search for any combination of text and numbers, but WITNESS Miner interprets the combination according to the type of the field that the action is applied to. For example: "1234" will be interpreted as the number 1234 when applied to a numeric field and the string "1234" when applied to a categorical field.
You can search and replace all fields in the database or a selected subset of fields.
If the search term is not found in any of the fields, no replacements take place and a message is recorded in the project log window.
Full details of the options available for the replace node can be found on the replace options page.
