topic Process multiple excel files with same schema but different worksheet names in Talend Studio

Process multiple excel files with same schema but different worksheet names

Anonymous — Wed, 07 Nov 2018 15:21:31 GMT

I have many excel files, approximately 40, with the same schema in different files with different worksheet names. I will be processing these files to a Greenplum db.
I would like to use tfilelist to process those files as one excel file, however, how do i state they have different worksheets names per file? Example:

File Type File Name # of worksheets Worksheet Name
xlsx TPS 5 CDW Data
xlsx IST 4 IST input
xlsx OFE 10 EDW Data
xlsx OFS 8 >> CDW

Appreciate what would be the best approach to this process. I am using TOS BD 6.3.1 version.

Thank you.

Re: Process multiple excel files with same schema but different worksheet names

Anonymous — Thu, 15 Nov 2018 07:35:53 GMT

Hello,

Could you please have a look at this related topic to see if it is what you are looking for?

Best regards

Sabrina

Re: Process multiple excel files with same schema but different worksheet names

manodwhb — Thu, 15 Nov 2018 07:58:28 GMT

@pkarnes325,you can specify the sheet name or position of sheet. that in you are designing the generic job to process multiple excel files you should make sure the position of the sheet is in same position.

Re: Process multiple excel files with same schema but different worksheet names

manodwhb — Thu, 29 Nov 2018 12:58:39 GMT

@pkarnes325,did it help you to solve the problem?