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!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.