I have an excel file composed of 4 sheets. I'd like to replace some values by other values in both sheets. Then, the output file would be the same excel file, composed of its 4 sheets with all the values, including those replaced.
I used tFileExcelWorkbook and tFileExcelSheetList to parse my Excel file, then tFlowIterate to create a global variable (name of sheet) and tReplace to make the search/replace.
But after I'm stuck.. How to make it to create the same excel file, with the same sheets by using tReplace component ?
Here is a screenshot of what I tried..
Would you have any solutions ?
Thank you very much for the help !
Talend named a Leader.
Kickstart your first data integration and ETL projects.
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