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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
laughsmile
Contributor III
Contributor III

If one Excel file fails, how does the job not stop and continue to process the next file?

Hello everyone.

We use tLogCatcher to handle the error and use tFileList to get a list of EXCEL files and tLoop to process files one by one. If one file fails, will the job not stop and continue to process the next files?

Thanks in advance.

Ryu

Labels (2)
3 Replies
laughsmile
Contributor III
Contributor III
Author

Hi monica46cole

Thanks for your answer.

You say: "configure the tLogCatcher component to handle the error and move on to the next iteration. You can set the error handling strategy to log the error and proceed with the next file in the loop."

But I can't find the setting in the  tLogCatcher component to handle the error and move on to the next iteration. Would you please show me how to do it by giving the visual representation? 

Ryu

Bhushan_Mahajan
Creator II
Creator II

@laughsmile Please SET ErrorMode=0

Dave_Simo
Creator II
Creator II

Hello,

To continue the iteration even if there is an error while processing a file you can this piece of code in tJavaFlex as below :

Dave_Simo_0-1736425645578.png

 

Dave_Simo_1-1736425673393.png

We see that the iteration continued well even if an error was encountered on the first Excel file.

Dave_Simo_2-1736425807948.png

Best Regards,