Reading multiple spreadsheet using unstructured datastage

parilango · Post by **parilango** » Wed Oct 19, 2016 10:49 am

I am trying to read multiple spreadsheet using unstructured stage but I am getting an error."Unstructured_Data_0: An error occurred when reading the specified file" If I click view it is opening blank page

if I have single spreadsheet excel. It is reading fine. any set up is missing?

Please help

chulett · Post by **chulett** » Wed Oct 19, 2016 3:18 pm

How did you configure the stage? Anything like what is detailed here?

parilango · Post by **parilango** » Wed Oct 19, 2016 3:55 pm

Input File : FileName.xls

Range Option: Specify the start row
Range expression: Sheet1!A1:K23
Sheet names to skip: 'Sheet2','Sheet3'
Column header: First Row of data ranges

when I click load it is giving error "An error occurred when reading the specified file"
View is opening the empty excel sheet

chulett · Post by **chulett** » Thu Oct 20, 2016 12:45 pm

I don't work with this stage so not sure how much help I can be but... let's start by clarifying what you mean by "read multiple spreadsheet" and "single spreadsheet excel". Are you talking about reading multiple files or a single spreadsheet file and you need data from multiple worksheets within it?

FYI, the article was about the latter.

abc123 · Post by **abc123** » Fri Nov 11, 2016 11:46 am

If you want to read multiple Excel files by using one unstructured stage, you need to use a wild card. So if you have files like this:

File1.xls
File2.xls
File3.xls

you need to put:

File*.xls

in the "File name" box after clicking the Configure button. In that case, you also need to check "Use template file for design time" and specify a "Template file name:". All the files need to be just like the template file in structure.