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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

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

Download