 | This guide will help you learn how to output the records with empty string fields. (An empty string is a field eaqual to "".) |
Configuration
To start filtering records,
- Configure data sources and provide the mapping
- Open the Filter (or Validate) node
- Click on the String section to find the Is Empty icon
- Drag-and-drop it to the Filtration's work panel
- As well, drag-and-drop the field that may contain empty records
- Map the nodes according to the picture below
- Press Ok to close the window
Now the output table will contain only those records where the specified text field is empty. You can preview the results or continue data integration.
See also
Is Not Empty Function
Is NULL Function
Is Not NULL Function