This scenario extracts data from an Excel 2007 file. It demonstrates the use of dynamic schema.
For more technologies supported by Talend, see Talend components.
The Job in this scenario comprises three subJobs.
- The first subJob writes data to an Excel 2007 file.
- The second subJob extracts data from the Excel 2007 file that is used in the first subJob; displays the data in the console; and then writes the data to a CSV file. Note that all the data operations in this subJob are carried out using dynamic schemas.
- The third subJob extracts and displays the data from the Excel 2007 file in the normal way.