I'm getting this error when trying to get the data into Output for multiple excel sheet tabs. I am new to Alteryx and I'm working on a workflow which someone else has built but keep getting error. I have added multiple Block Until Dones before the Output tool but still that doesn't seem to be working. Can someone please advise me. It looks like quite a big workflow so I put it in 2 images
Request you to please advise asap. Thanks!
Control Containers will be your best bet: Control Containers: Take Control of Your Workflow - Alteryx Community. Use Case #1 should apply to you!
I am not sure - I would see what's unique about that one compared to the others and try different things to fix it. Hard to guess from screenshots
Thank you, looking at this and comparing it to mine. Would I just move my outputs into control containers and connect them? EG
Yes exactly - but each output would have a control container. Aka if you have 12 outputs, you should have 12 control containers, all linked together!
Thank you and I assume it'd be something like this? I've got about 25+ outputs so would have to do that many. I've just made a start with the first 4
Hi so I added all the outputs and put them into their own control container. Now I am just getting this error on the last control container
Yes that looks correct - I would check for other errors upstream and make sure those are fixed!
That just seems to be the only error now on the final control container. I thought maybe it was because it needed an output to go to and I sent it to Message tool that just says "End of run" but this also didnt seem to work
What happens when you remove that last container?
It looked like it managed to run once I removed the last one. Strange. How can I get it to run with the last one that I wanted?
Okay thank you for your help, I will have a look 🙂
I managed to figure it out, the last control container wasnt working because it was a summary of my phase 2 and I had phase 2 switched off silly me. Thank you very much!
Great news!