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

[Anonymous]

Hi

You can use one tFileInputExcel to read all the sheets

read all sheets in one component.PNG

[TharunJoshi]

Can I do it for all the tables from single excel file,1 tmap,4db connections.If yes how can I if you show it with example highly appreciated

[Anonymous]

Hi,

In the case each sheet has his own structure, you can't do that. You will probably handle each sepperatly

[akumar2301]

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 ?

[TharunJoshi]

Hi,

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

Thank Yo

Capture.PNG

[Anonymous]

I think you may need to put tMap between each Worksheetn and DBn

..................... Worksheet(n) ----- tmap ----------- DN(n)

But, if there is no need to transform the data, then you can do without the tMap

I hope this will help.

[TharunJoshi]

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.

4.like worksheet1-->P

         worksheet2--->Q

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

[nivedhitha]

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?

[TharunJoshi]

Yes I do have some business logic, I don't have subscription