Replace Null Values

Overview

This operator supports replacing Null values in text and numeric fields. You can use the default replacement behavior or define custom replacement values as needed. When performing field-level statistics, existing Null values may affect result accuracy. Replacing them with 0 or other values helps ensure more complete and reliable analytical results.

Procedure

Text fields containing Null values are replaced with empty strings by default, while numeric fields containing Null values are replaced with 0 by default. You can also customize the replacement content. The same result can also be achieved through the Replace Values operator, but replacing multiple numeric values would require multiple operators.

Preview Before Replacement:

Preview After Replacement: