concatenation of data in Talend

Concatenating data from two columns  and data loading in single column the output data should place in excel file

Components:

Tredshift input:  Reads the data from DataBase and Extract field based on query.(extract data based      on condition)

                               

Tmap:  tmap transforms and routes data from single or multiple sources to single or multiple destinations.

                               

tfileOutputExcel:  tfileOutputExcel outputs data to an MS Excel type of data.

                               

Mapping as shown below

 

 

Dropping and Linking components:

1.    Drop a tRedshiftInput, a tmap, a tFileoutputExcel on our design.

2.    Link tRedshiftInput to tMap using a Row > Main connection.

3.    Link tMap to tFileoutputExcel using a Row > newOutput(Main).

 

Steps to follow:

1.       Give connection credentials for source i.e.,(tredshift Input component)

               

 

 

2.       Retrieve table from required schema and click guess query or paste the user query  in query Box.

 

U Using tmap concatenating two columns that map as shown below

 

 

 Above screen shot from source table (as_of_date, scenario) both columns are mapping in target table scenario colum by using tmap component.

 

4.       Concatenation expression as shown below

 

5.       In tfileoutputExcel give path for file where we want to store and mention extension of file save  .xls (the data should store in Excel format ).

 

 

6.   Output: