Output Data - more then four sheets

Hi everyone,

I want to export multiple sheets within an excel file. Till four sheets, the block until done tool was sufficient. With more then four block until done tools I get an error that two processes run at the same time (writing a file). Does anyone know another method to write multiple sheets within one excel sheet? Thank you in advance!

Output

Accepted answers

AdamR_AYX

@BasLuther I think the Parallel Block Until Done tool from the CReW macro pack (http://www.chaosreignswithin.com/p/macros.html) will do what you need.

Set up your outputs like above and replace the text inputs with the data to write to each excel sheet.

ParallelBlockUntilDone.yxmd

All comments

JordanB

Hi @BasLuther

You can use this article to get what you need: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Output-to-multiple-sheets-within-an-Excel-file/ta-p/1241

Best,

Jordan Barker

Solutions Consultant

BasLuther

Hi @JordanB

Thank you for the reply

I found the article, but what is still not clear for me is if you als have multiple input streams. Normally you would use two output tools with one block until done. Now if you use more then three block until done tools, you'll get an error. Is there any way you could solve this problem, use another method?

kind regards,

Bas luther

JordanB

Hi @BasLuther

Are there specific records you want outputted into different files? Or are you outputting files at different points of the workflow?

Best,

Jordan

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167