Dashboard > APATAR FUNCTION GUIDES > Apatar Function Guides > Is Not Empty Function
  APATAR FUNCTION GUIDES Log In | Sign Up   View a printable version of the current page.  
  Is Not 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 configure the Is Not Empty function and filter out the records with an empty field.

Please, follow these steps:

  1. Drag-and-drop source connectors and necessary operation node (Transform, Filter, or Validate) to Apatar's work panel.
  2. Configure the source connectors and then map them with the operation node.
  3. Double-click on the operation node to open the transformation or filtration window.
  4. Drag-and-drop the field that contain unwanted empty records to the operation's work panel.



  5. If you are using the Transform module, switch to the Function tab, as well.
  6. Click on the String section to view related functions.
  7. Drag-and-drop the Is Not Empty function icon.



  8. Map the nodes according to the following picture.



  9. Click Ok.

Now you can run the filtration.

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