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

This guide will help you learn how to count a number of characters in the specified text strings using Apatar.

Configuration

To start determining the length of the strings,

  1. Configure data sources and provide the mapping



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



  2. Open the Transform node
  3. Switch to the Functions tab
  4. Click on the String section to find the Length icon
  5. Drag-and-drop it to the Transformation's work panel



  6. Map the input and output fields according to the picture below



  7. Press Ok and close the Transformation window

Now the output table will contain the numbers of characters in the Column field strings.

Preview

To preview the results, right-click on the output node and select "Preview Results". The following window will pop up:

           

Close the window and continue data integration.

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