Output 500,000 rows—into a single CSV file in Alteryx Designer Cloud

Question

Hello Everyone,

I could use some assistance with an issue I'm encountering in Alteryx Designer Cloud.

I am working with 22 Excel files that contain similar data, which I’m stacking using the Union tool. The data appears correctly in the preview, and I would like to output the combined result—approximately 500,000 rows—into a single CSV file.

However, when I run the workflow, I consistently receive an "AsyncRequestTimeoutException" error. Interestingly, the workflow completes successfully when I limit the output to just 1,000 rows.

I'm wondering if there is a recommended way to handle larger datasets in this environment. It's a bit surprising to run into this issue, considering Alteryx is built for data processing.

Any suggestions or best practices would be greatly appreciated.

Thank you!

alexnajm · Answer

Got it!

JacEvaluator · Answer

I think i know why. I was on the trial account. In trial they limit a file size of 40Mb max. So it is not about the rows, it is about the final output size not exceeding 40Mb. My combine output size is 150Mb.

alexnajm · Answer

I was able to write 1M to a csv just fine, so I would do the above ^