This guide will help you learn how to output the records with NULL fields. (NULL is a marker used to indicate that an entry is uninitialized and the data value is unknown.)
To start using the Is Null function,
Configure source connectors and map them with an operation node (Transform, Filter, or Validate)
Double-click on the operation node to open the transformation or filtration window
Drag-and-drop the field that may contain NULL records to the operation's work panel
If you are using the Transform module, switch to the Function tab, as well
Drag-and-drop the Is Null function icon
Map the nodes together
Click Ok
Now the output table will contain only the records where the specified field is NULL.
Site running on a free Atlassian Confluence Open Source Project License granted to Apatar Data Integration (ETL). Evaluate Confluence today.