when i read the data from a excel shht that contain a row that will be a formula it returns "NULL" or "#VALUE". How can i get the calculate value of the cell. e.g.
ROW A | ROW B | ROW C
1 | 2 | =A+B
When i read the File with the component "tFileExcelSheetInput" or "tFileInputExcel" i get "NULL" or "#VALUE" How can i get the Result "3"
Thanks and Regards
I'm assuming your excel sheet looks more like:
ColA ColB ColC 1 2 =A2+B2
If so, then this should work fine. If not, please show a screenshot of your Excel sheet and include the formula in question.
yes it looks so. but it don't work. in the screenshots you can see the excelsheeet and the result in talend. in my question it will be only a simple example.
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
Practical steps to developing your data integration strategy.