ApatarForge
  Dashboard > APATAR FUNCTION GUIDES > Apatar Function Guides > Less Than Function
  APATAR FUNCTION GUIDES Log In   View a printable version of the current page.  
  Less Than Function
Added by Alex Khizhnyak, last edited by Alex Khizhnyak on Jan 16, 2008  (view change)
Labels: 
(None)

This guide will help you learn how to grab the records that are less than a specified value.

Configuration

To start the filtration,

  1. Do the mapping and configure data sources and outputs



    In this guide, we will use the following table as a source:



  2. Double-click on the operation node (Filter, Transform, or Validate)
  3. Drag-and-drop to the work panel the field that will be compared



  4. Drag-and-drop the Less Than function
  5. Map the field with the function



  6. Double-click on the Less Than node
  7. Specify a number (or a string) to compare with



  8. Click Ok
  9. Close the filtration work panel

Preview

Now you can preview the result.

          

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