Replace NULL and missing values as part of ETL for data quality?

[GeorgeQV]

Dear all,

Suppose within the ETL process, I extract a table as following:

The NULL resulted from a JOIN, the missing value in Field2 of row "b" is just empty.

[Gysbert_Wassenaar]

What do you want to do? And where? In the script?