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
from source Name should be mapped with destination Name
my end file should looks like below,
Kindly someone help me its urgent
Solved! Go to Solution.
Use tNormalize Component also you could implement the below logic inside tmap (output side) under expression editor.
row1.Name+ "|" + row1.age+ "|" + row1.id;
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.