Merging the content of several columns

Talend Data Preparation Quick Examples

author
Talend Documentation Team
EnrichVersion
6.5
2.3
EnrichProdName
Talend Data Services Platform
Talend Big Data
Talend Real-Time Big Data Platform
Talend Data Integration
Talend Data Fabric
Talend MDM Platform
Talend Big Data Platform
Talend ESB
Talend Data Management Platform
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation

In some cases, the data you want to use is split in several columns. You can group these columns using a concatenation.

All the information you need to create the email addreses is now ready, and you only need to assemble it. You will merge the three columns that you have created since the beginning of this scenario.

Procedure

  1. Select the Email_First_Name column.
    When merging several columns together, the one that you select at the beginning, Email_First_Name in this case, will be the first part of the merged column that will be created.
  2. In the functions panel, type Concatenate with and click the result to display the options of the associated function.
  3. Configure the function as follows:

    You can only concatenate two columns at a time, so you will begin by merging the Email_First_Name column with the Email_Last_Name, with . as separator.

    You have the possibility to output the result of this function in a new column by selecting the Create new column check box.

  4. Click the Submit button to apply the function.

    A new column with the merged content from the two columns is created.

  5. Proceed the same way to merge the column you just created with the Email_Domain column, but using @ as separator this time.

Results

The content of the three columns has been merged. You have created a column containing valid email addresses, based on first names, last names and a web domain for each company.