I am new to Talend and trying to read through multiple dynamic worksheets in the excel workbook and load data to table.
tFileInputExcel -> tMap -> tOracleOutput works to load the data from all sheets to table.
But I need to get each worksheet name and check the name to derive a boolean value in addition to load the data in worksheet to table. The table columns looks like below
Any help or comments are helpful.
In the tMap component you may access the current sheetname using the following expression (replace the tFileInputExcel # by yours):
So, you can compare its value with what you want to populate the boolean field as desired.
The component tFileExcelSheetList is designed to do that.
what if i don't have a component called tfileexcel sheet and also tried tmap component I couldn't do it
Thats easy. Use the component tFileExcelSheetList to iterate through the sheets and use within the iteration tFileExcelSheetInput to fetch the data. You can use the return value from the tFileExcelSheetList using as sheet name for tFileExcelSheetInput. Both referencing to tFileExcelWorkbookOpen in which you open the file.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend
Learn how and why companies are moving to the Cloud
Accelerate your data lake projects with an agile approach