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

[JacEvaluator]

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]

@JacEvaluator people may have answers, and I can try this myself later, but in the meantime I would recommend submitting a case to Alteryx Support so they can take a look as well! MyAlteryx

[alexnajm]

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

[JacEvaluator]

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]

Got it!