Mapping multiple column into single column

Highlighted
Six Stars

Mapping multiple column into single column

Hi All,

 

I have two excel files source file and destination file.

My source file contains 3 columns (Name,Age,Id)

My destination file will have only 1 column which includes all the headers into single column

ex:

Destination file 

Capture.PNG

 

 

from source Name should be mapped with destination Name 

 

my end file should looks like below,

 


Capture1.PNG

 

Kindly someone help me its urgent

 

 

Regards,

Abisha

 

 

 


Accepted Solutions
Nine Stars

Re: Mapping multiple column into single column

Hi,

 

Have you tried just outputting using a tFileOutputDelimited and setting the delimiter as a pipe "|"?

Regards David
Dont forget to give Kudos when an answer is helpful or mark the answer as the solution.

All Replies
Nine Stars

Re: Mapping multiple column into single column

Hi,

 

Have you tried just outputting using a tFileOutputDelimited and setting the delimiter as a pipe "|"?

Regards David
Dont forget to give Kudos when an answer is helpful or mark the answer as the solution.
Eleven Stars

Re: Mapping multiple column into single column

use below expression in tjavarow or in tMap between reading INPUT excel and OUTPUT excel.

output.OutputCol = input.Name+ "|" + input_.age+ "|" + input_row.id;
Regards
Abhishek KUMAR
Six Stars

Re: Mapping multiple column into single column

Use tNormalize Component also you could implement the below logic inside tmap (output side) under expression editor. 

row1.Name+ "|" + row1.age+ "|" + row1.id;

Six Stars

Re: Mapping multiple column into single column

Yes i did that only
TfileinputExcel->tMap->tFileOutputDelimited

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch