Dashboard > INTEGRATION GUIDES > Integration Guides > Concatenating Data Fields
  INTEGRATION GUIDES Log In | Sign Up   View a printable version of the current page.  
  Concatenating Data Fields
Added by Alex Khizhnyak, last edited by Alex Khizhnyak on May 16, 2008  (view change)
Labels: 
(None)

This guide will help you learn how to concatenate two fields into one.

Concatenate Function Configuration

To use the Concatenate function, follow the steps bellow.

  1. Open the Transform or Filter module



  2. Switch to the Function tab (the left column)
  3. Then click the String section, and you will see all of the available functions. The Concatenate function is supposed to be there.
  4. Drag-and-drop it to the work panel
  5. Switch to the Input tab at the left column
  6. Drag-and-drop the fields you want to concatenate, as well
  7. Map them with the Concatenate node



  8. Drag-and-drop the output field and map the Concatenate node with it
  9. Click Ok

Now you can run the transformation.

See also

     Related Forum Topic

     Append Function

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