tfilelist

[TharunJoshi]

Hello,

My Excel File name is PIGEON it has four worksheets

P

Q

R

S

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.

Suggestions Please

 Worksheet 4-------->mssqlDB 4-------->save the file with ts

[nivedhitha]

@TharunJoshi 

if there are business logics, then you have to process each sheet separately. 

[TharunJoshi]

You mean to say from four worksheets i have to download each worksheet separately and make four excel sheets and tmap

[TharunJoshi]

https://exchange.talend.com/?_ga=2.147780144.629817436.1558953759-691553473.1558680704#marketplacepr...

can you check this once

[nivedhitha]

@TharunJoshi 

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