Replace Null Values

Overview

This operator supports replacing Null values in text and numeric fields. Users can define custom replacement content as needed. During field statistics, Null values may affect result accuracy. You can replace these values with 0 or other content to ensure statistical completeness and correctness and avoid the impact of missing data on analysis.

Instructions

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:

Why were some null values not replaced successfully after using Replace Null Values in ETL?

For other data processing operators used later, see Getting Started.