Wanted to write output into 10 different worksheets in same Excel sheet

[Ram_RK]

Team, please help on writing the output into 10 different worksheets in one single Excel Shet 

[Deano478]

You can take 2 approaches:

1. Use a cascading block until done approach

2. Make of use of the Crew Macros Parallel Block Until Done

[binuacs]

@Ram_RK There are multiple ways you can achieve this, if you want to write your output into different sheets based on a field then you can go with the below option. If your requirement is different then provide a sample input file and expected output.

[Ram_RK]

Block until done supports only 3 tasks and I don't have parallel block until done as its not available in Alteryx Version : 2022.3

I have checked with Block until done its not working for me. 

[Ram_RK]

This option is not working for my version as its Alteryx 2022.3

Please suggest if any other way possible.

[binuacs]

@Ram_RK it should work in all the version. can you provide a sample input file and expected output?

[Ram_RK]

Hi 

Hi @binuacs the expected output in below format but it's getting error stating the xlsx is already open.

[binuacs]

@Ram_RK This is not the correct way of approaching your use-case. Would you able to provide a sample input file?