Process multiple excel files with same schema but different worksheet names

[Anonymous]

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.

[Anonymous]

Hello,

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

Best regards

Sabrina

[manodwhb]

@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.

[manodwhb]

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