Block Until Done - Working Partly

Question

Hello,

I have almost 50 sets of outputs (using Render tool) being produced in my Alteryx workflow. I wait for them to finish processing before calling the Run Command Tool to zip it all. I have this working using multiple Block Until Done Tools (see below for example):

(this is repeated for each output so I can wait for them to finish writing before I zip them.

This works for all 50 outputs. I just added another output (using Output Data tool this time and not the Render tool) and added the same Block Until done and added that connection to the Union tool. Unfortunately it does not wait for the latest file that I have added and zips the other 50 up and in the end outputs the last file. I thought it should still wait for all 50 files like it used to and then the additional file so 51 files before it zips them up.

Any thoughts on why it might happen? What's different with the new file is that it is being output using normal Output tool and not the Render tool and has different columns that I'm joining on since I'm not using the Render tool. Any help is appreciated!

AkimasaKajitani · Answer

Hi @avanibhatnagar

Which engine do you use to run the workflow by AMP Engine or Alteryx Original Engine?

Depending how to make the workflow, it work well or not by using AMP or Alteryx Original Engine.

Or please try to use the Parallel Block Until Done tool that is contained in Crew Macro.

http://www.chaosreignswithin.com/p/macros.html

avanibhatnagar · Answer

@AkimasaKajitani Thanks for your response!! It does - it writes to a csv file, whereas the other render tools write to excel files. I just don't understand why the other Block Until Done tools work, but this one processes after the other files are zipped. My powershell is supposed to pick up all excel and csv in a folder, but it can't pick up the csv since it is produced after the zipping is already done.

AkimasaKajitani · Answer

Hi @avanibhatnagar

Thank you for your reply. Certainly, my solution can't apply at your situation.

By the way, does the New Output Data tool save the some data?

If there is no data and it set by overwrite sheet or range option, the Output Data tool save at the last.