Skip to main content

Replace Null Values

1. Overview

Supports replacing Null values in text and numeric fields, with user-defined replacement content. You can set specific replacement content as needed. When performing field statistics, existing Null values may affect the accuracy of the statistics. You can replace these Null values with 0 or other content to ensure the completeness and correctness of the statistical results and avoid the impact of missing data on analysis.

2. Usage Instructions

Text fields with Null values are replaced with empty by default, and numeric fields with Null values are replaced with 0 by default. You can also customize the replacement content. The same function can also be achieved with the Replace Values operator, but replacing multiple values requires multiple operators.

Preview before replacement:

image.png

Preview after replacement:

image.png

[Why are some null values not replaced after using null value replacement in ETL?](../../../../11-FAQ/1-Data Processing/2-ETL FAQ.md)

For subsequent use of other data processing operators, see Getting Started.