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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Runtime memory exception while loading an excel file

Hi, I am trying to create a Job with excel file as an Input source. However, since the file size is huge (around 18 MB), I am getting a runtime exception while creating an excel file. Attached is the screenshot for the same. Kindly suggest how to handle large files.

0683p000009LvN2.jpg

Labels (2)
1 Reply
cterenzi
Specialist
Specialist

If you're reading an xlsx file, you'll want to tick that box below the file name. That will enable the Generation mode dropdown, which will let you select Event Mode. This reduces memory usage and should avoid the heap space issue.