My Excel File name is PIGEON it has four worksheets
1.For this I know I can do this job separately by creating different jobs but I want to do it at one go because the EXCEL file and the columns inside it will not change.
2.There will be a possible solution by using only one TFILELIST I can ITERATE to all the worksheets and the outputs of all can be attached to only one TFILECOPY.
Worksheet 4-------->mssqlDB 4-------->save the file with ts
You can use one tFileInputExcel to read all the sheets
Do you want to split different excel sheet in different file/DB Table?
- Are you tMap logic same for each sheet ? if not , you need to create a separate subjob.
- Are you using different table for different sheet ?
Please Check, this is how I want and Please describe it clearly so that I can implement in the way which you say.
If I can use only one TMAP for all the worksheets can tell me how you can
I think my question is not getting a correct answer yet
4 worksheets in one excel
1.Can it be processed using tfilelist?
2.Each worksheet has different data and different datatypes.
3.Each worksheet should be loaded into each different table.
5.Can we do this using 1tfilelist --->1tinputexcel(with 4 worksheets)---->tmap(with 4 worksheets)--->4output table P,Q,R,S
Is their anyway other than this please let me know
Hi @TharunJoshi ,
it is possible to use one tFileInputExcel and iterate over each sheet.
but before that can you let me know if there are business logics applied to the source data from excel before loading into db?
And do you have talend subscription?
you don't need any custom components.
the simplest would be to create a job like this.
the tFileInputExcel has option to specify the sheet name
that is how it has to be configured for your 1st sheet. give the name of the sheet ("P" in your case) or 0 (automatically picks the first sheet) for the first tFileInputExcel input the corresponding schema for it and then do the business logic in tMap.
In the second subjob,
the sheet name has to be "Q" or 1, schema for the second sheet and map it to the corresponding table.
And so on for the subsequent sheets.
Let me know if you have any trouble
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema