Render Tool out of memory and larger than size 300 MB.

[faisal9999]

I am facing an big issue while running the workflow. First, it's taking too much time to run the workflow.

Please check yellow highlighted one and please provide an solid solution to optimize the time execution or this memory issue.

Although I have tired ways of increasing memory limit but it does not resolve my issue.

[apathetichell]

Render breaks around 50K rows. I'd recommend looking for an alternative solution (like the create all the sheets through Render --- but only have the 120K row sheet create one line). After file is created --- use output data to fill in that data on that sheet.

[stonerje]

Can you elaborate on this... I am having same problem where report over 50k rows needed to be formatted

[apathetichell · Accepted solution]

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Output-data-after-render/td-p/...

to be clear ---> this assumes that you do not need your bulk data (large output) to be formatted. If you do -> you would need to use a blob template with preapplied format. or something coded (visual basic/python).