I require some help with a Basic Job. I?m importing data from a .cvs file to an excel file. I used tMap to JOIN in the Data.
I used an excel template (TimeSheet_Report_Test.xlsx) with some formulas in it. The Data exports to the excel just fine, but the formulas in the excel do not take effect when the data is exported to the excel file.
Hence the Formulated Columns to not change.
Does someone have a solution for refreshing the formulas in the column so they can take effect on the data?
I'm using File Delimited > tMap > tFileOutputExcel
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.