ApatarForge
  Dashboard > APATAR FUNCTION GUIDES > Apatar Function Guides > Is Null Function
  APATAR FUNCTION GUIDES Log In   View a printable version of the current page.  
  Is Null Function
Added by Alex Khizhnyak, last edited by Alex Khizhnyak on Dec 29, 2007
Labels: 
(None)

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,

  1. Configure source connectors and map them with an operation node (Transform, Filter, or Validate)



  2. Double-click on the operation node to open the transformation or filtration window
  3. Drag-and-drop the field that may contain NULL records to the operation's work panel



  4. If you are using the Transform module, switch to the Function tab, as well
  5. Drag-and-drop the Is Null function icon
  6. Map the nodes together



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