I am writing a flow that writes to a single Excel file, but two different sheets on that same file. Just sometimes, the machine will race ahead of the file lock, even when using BlockUntilDone, and I get the odd error where the OS reports the Excel file as locked open, even though it is imminently about to close.
Is there a something I can give Alteryx to do on BlockUntilDone's 2-stream that will keep Alteryx busy for a few milliseconds, before attempting the second write on the 3-stream?
I know about the (most excellent) Crew Macro for waiting, but does anyone have a suggestion for a quick and dirty solution that just distracts Alteryx for a maybe 300ms or so, to give the OS time to unlock the file? In coding I would just do a for-loop to count to a million or something (but not that exactly, coz that's stupid). At the moment I am writing a dummy file on stream 2, and that works, but I would welcome suggestions that make Alteryx do something, but does not burn CPU or RAM.
Solved! Go to Solution.
@Hiblet - I generally tend to use the Render Tool in cases like yours. Take a look at the attached sample solution. May not necessarily apply in your case, but still worth a look.
Thanks @AbhilashR, that is exactly the kind of thing I was thinking of. Something that takes a bit of processing, but does not ludicrously tie up the machine and waste resources. Much obliged!