Mapping multiple column into single column

[Anonymous]

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

[David_Beaty · Accepted solution]

Hi,

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

[akumar2301]

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

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

[dipanjan93]

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

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

[Anonymous]

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