Parallel Block Until Done does not work with AMP engine

ypt

Hi there!

I have been testing out a few ways to use the Parallel Block Until Done (PBUD) tool for multiple tabs output to the same Excel file as I have several upstream input files and Block Until Done tool itself will not work and I do not wish to union the different datasets.

1. Turn on AMP engine and 'Unable to open file for zipping' error occurs

2. Turn on AMP engine and ensured the tool containers and output tools are in sequence and  'Unable to open file for write' error occurs

3. Turn off AMP engine and use PBUD tool - ok

4. Turn off AMP engine and removed PBUD tool - ok

In conclusion, I found that as long as the AMP engine is not turned on, I do not need the PBUD tool BUT the workflow will take much longer to run. 

Is there a way to turn on AMP engine and still use PBUD tool?

Thanks in advance.

MarqueeCrew

@ypt ,

pBUD won't operate with AMP.  A trick that I used before writing pBUD (still I use it) is to count the number of records in my first Excel WRITE before I send data to my second Excel WRITE.  Hopefully, that counting gives your disk a chance to complete (same as pBUD) before it starts sending data to the 2nd sheet.

Here is a before pic:

This just won't work.  Excel Sheet 2 will 100% fail.

But if you count the records from #1 and use an APPEND FIELDS tool (uncheck the count), it will nearly 100% work.  Here is a pic:

Until Alteryx provides some sort of control or order, this technique will allow #2 to be blocked until all data from #1 has passed through the blocking SUMMARIZE tool.  Another technique is to use a BATCH macro.

Cheers,

Mark