Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Loading multiple Excel files using tFileList and tFileInputExcel

I set up a job that loads a file using tFileInputExcel to a MySQL database table and it works correctly.
I then added the tFileList component  and set up to iterate through tFileInputExcel. The job picks up the three files in my directory that is referenced in tFileList and loads them correctly into the database. But the job ends with an error: 
Exception in component tFileInputExcel_1 : Compound file does not contain the specified stream
any ideas on why this might be?

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Here is the export from the job
FileList_delimitedatabase_treplace_date2_0.1.zip.zip

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Here is the export from the job
FileList_delimitedatabase_treplace_date2_0.1.zip.zip
vapukov
Master II
Master II

You need to check what difference between first 3 and 4th files
even if You have 3 file, You need run Job in debug mode (may be add tLogRow for display processed file name) and check what happens
for example - hidden files in directory 
Check tFileList catchup pattern and exclude pattern to be sure - You work only with proper files
Anonymous
Not applicable
Author

Thank you. I only have 3 files, I will look for hidden files and/or change the tFileList pattern.