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
Reading multiple spreadsheet using unstructured datastage
Moderators: chulett, rschirm, roy
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.
FYI, the article was about the latter.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
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.