Blob Tool / Combo with Block Until Done Not Working - Processing Too Quickly

[mdreynard]

Hi All,

I've tried to search around to see if anyone else was having this issue and it was inconclusive.  I've got a workflow that utilizes a Blob tool to copy/paste/rename an excel template file and then further in the process, insert data into that template.  I'm running into an issue where the flow processes so fast, it doesn't seem to be enough time for the blob tool to save it to the drive, then reopen it and insert the data into it.  I can turn off those pieces of code individually after running to make it work, but I can't make it work all in tandem.  I've tried the block until done tool in various places, etc.  Any suggestions?

Attached is a picture of the part of the workflow in question, albeit with some redacting.

[OllieClarke]

@mdreynard if you're on version 2023.1 or later the control containers will solve this issue - https://community.alteryx.com/t5/Engine-Works/Control-Containers-Take-Control-of-Your-Workflow/ba-p/... 

I'm assuming the blob tools should run first, then the output tool?

If you're on an older version, then it's a bit trickier.

You could create batch macros of the 2 containers, so you can run them sequentially. This is a bigger effort, but would be an efficient solution once created

You could also try generating lots of rows, and then summarising them back down immediately before the output tool to slow down that process. This is a quicker 'fix', but isn't efficient

The BUD acts as a gatekeeper of records, not processes, so the Blob output can still be running when records are passed out the 2nd output of the BUD and into the Output tool

[mdreynard]

Thank you!

I am on a 2022 version so I think I'm going to try to work with my IT to upgrade if I can since that seems the more straightforward route.  Appreciate the options laid out for this!

[alexnajm]

I would also consider turning off AMP Engine if it is on - it will sometimes blow by Block until Done tools!

[mdreynard]

---

@alexnajm wrote:

I would also consider turning off AMP Engine if it is on - it will sometimes blow by Block until Done tools!

---

Unfortunately I tried that already, did not resolve the issue.

[SPetrie]

Depending on how you used the block until done, you may have had it setup incorrectly.

It only works if all your data flows through it, simply having it on a branch will not work.

Your setup would need to look something like this where it would complete branch 1 then 2 and then 3 (if I had something hooked to it).