Create Excel files larger than 100MB
I need to create an Excel file which is larger than 100MB in file writer. I am receiving an error message in File Writer: Possible reasons can be failure in URL connection or file access denial, de...
Forum Discussion
The filename in your File Writer is a static string; click on the equal sign to enable it as an expression (i.e. it will appear darkened). This will allow the file to be written to a temporary directory (since you are using pipe.tmpDir) on the snapex execution node and prove that the Excel Formatter is able to handle the data volume. Please review the File Writer snap documentation to gain an understanding on how you could write to an alternate endpoint that you can safely store the file over 100MB.
Hope this helps!
I changed the equal sign and now it run with no errors. However, the file was not created in the GDrive. The issue is probably in File Writer. There is one file with size over 200MB on the input, but 1 file with 0 bytes on the output. Any thought on this?
