Dashboard > APATAR FUNCTION GUIDES > Apatar Function Guides > Is Empty Function
  APATAR FUNCTION GUIDES Log In | Sign Up   View a printable version of the current page.  
  Is Empty Function
Added by Alex Khizhnyak, last edited by Alex Khizhnyak on May 15, 2008  (view change)
Labels: 
(None)

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,

  1. Configure data sources and provide the mapping



  2. Open the Filter (or Validate) node
  3. Click on the String section to find the Is Empty icon
  4. Drag-and-drop it to the Filtration's work panel



  5. As well, drag-and-drop the field that may contain empty records
  6. Map the nodes according to the picture below



  7. 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

Site running on a free Atlassian Confluence Open Source Project License granted to Apatar Data Integration (ETL). Evaluate Confluence today.
Contact Administrators