tFileInputExcel_1 : Open the xls file
tMap_3 : Add the column Date at the end the field is in format string and I use TalendDate.getCurrentDate()
tFileOutputExcel_3: Save the files with the column Date
tFixedFlowInput_1 : Add two rows at the bottom of the xls
tFileOutputExcel_4: Save the xls with the rows added.
I have try the TalentDate.parseDate("dd-MM-yyyy",row1.Date) with a second tMap between the tFixedFlowinput and the second tFileOutputExcel.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Test drive Talend's enterprise products.