Talend flow is given below
InputDBTable-->Excel-->tMap-->OutputDBTable (Input and output table is same)
Here, excel has formula in last 2 column's and i need to pull those results back to OutputDBTable. I have given the below formula in tMap but its showing me an error. Have anyone gone thru this scenario? Please suggest a solution to it.
Solved! Go to Solution.
A .xlsx file is a zip archive. No conversion is needed. just unarchive.
So if you unzip the file... there are multiple xml files which you could read with xml reading.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables