Skip to main content Skip to complementary content

Concatenating first and last names in a list of leads

A pipeline with a source, a Field concatenator processor, and a destination.

Before you begin

  • You have previously created a connection to the system storing your source data.

    Here, a Test connection.

  • You have previously added the dataset holding your source data.

    Download and extract the file: concatenate_us_leads.zip. It contains a list of US leads with first names, last names, cities and states.

  • You also have created the connection and the related dataset that will hold the processed data.

    Here, a dataset stored in the same Test connection.

Procedure

  1. Click Add pipeline on the Pipelines page. Your new pipeline opens.
  2. Give the pipeline a meaningful name.

    Example

    Concatenate first and last names in a list of leads
  3. Click ADD SOURCE to open the panel allowing you to select your source data, here data about US leads.

    Example

    Preview of a data sample about US leads.
  4. Select your dataset and click Select in order to add it to the pipeline.
    Rename it if needed.
  5. Click Plus and add a Field concatenator processor to the pipeline. The configuration panel opens.
  6. Give a meaningful name to the processor.

    Example

    concatenate first/last names
  7. In the Configuration area:
    1. Select Concatenate with value/another field in the Function name list.
    2. Select .firstname in the Fields to process list, as you want to concatenate this field with another one.
    3. Enable the Create new column option, and enter fullname in the Rename new column field, as you want to create a new output column that will contain the result of the concatenation operation.
    4. Select Other column in the Use with list, and select .lastname in the Column list, as you want to concatenate the .firstname field with the .lastname field.
    5. In the Separator field, enter a space as you want to use the space as a separator in the combined first and last names.
  8. Click Save to save your configuration.

    Look at the preview of the processor to compare your data before and after the operation.

    All first and last are now combined with a space as a separator.

    Preview of the Field concatenator processor after concatenating records about first names and last names.
  9. Click ADD DESTINATION and select the dataset that will hold your processed data.
    Rename it if needed.
  10. On the top toolbar of Talend Cloud Pipeline Designer, click the Run button to open the panel allowing you to select your run profile.
  11. Select your run profile in the list (for more information, see Run profiles), then click Run to run your pipeline.

Results

Your pipeline is being executed, the data is concatenated according to the conditions you have stated and the output is sent to the target system you have indicated.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here