Skip To Content

Replacing missing variables (nulls) with 0s

There are often several columns that have the same data type and need the same cleanup rules applied. For instance, if you want to replace missing variables (nulls) with zeros, this is done in the Cleanse Node. Hold down the Ctrl key and select multiple variables – applying the same “Replace with 0” to them all at once.

In the Cleanse Node, when you go to establish your cleanse operations, hold down the Ctrl key down as you click multiple columns on the left side of the pane. Then, the rule you established will apply to all selected columns once you click Add. All of the columns you multi-select have to be the same data type for this to work.

 

Cleansing multiple in Construct

Back to Knowledge Base