topic Re: Mapping multiple column into single column in Talend Studio

Mapping multiple column into single column

Anonymous — Tue, 22 Jan 2019 11:09:19 GMT

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

from source Name should be mapped with destination Name

my end file should looks like below,

Kindly someone help me its urgent

Regards,

Abisha

Re: Mapping multiple column into single column

David_Beaty — Tue, 22 Jan 2019 11:21:09 GMT

Hi,

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

Re: Mapping multiple column into single column

akumar2301 — Tue, 22 Jan 2019 11:23:29 GMT

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

output.OutputCol = input.Name+ "|" + input_.age+ "|" + input_row.id;

Re: Mapping multiple column into single column

dipanjan93 — Tue, 22 Jan 2019 12:21:40 GMT

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

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

Re: Mapping multiple column into single column

Anonymous — Tue, 22 Jan 2019 14:44:47 GMT

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