Block Until Done not working as expected

Hi,

I have a requirement to read a bunch of .csv files at once, process them for some calculations and then dump the original rows in another source table. For this, i tried to use Block Until Done tool as shown below, where i expected the flow from output 1 to get complete first and the data dump to happened from output 2. I observed that even when there is an error in the processing part, the data is still reaching to the source table, which is not correct.

Am i missing something here or there is some other way to achieve this?

Block Until Done.PNG

Output

Accepted answers

Joe_Mako

How about Parallel Block Until Done from the CReW Macro Pack: http://www.chaosreignswithin.com/p/macros.html

A way to think of the Parallel Block Until Done tool is: the stream into input 1 must be fully complete (and no stopping errors) before the stream to output 2 is processed.

All comments

Joe_Mako

How about Parallel Block Until Done from the CReW Macro Pack: http://www.chaosreignswithin.com/p/macros.html

A way to think of the Parallel Block Until Done tool is: the stream into input 1 must be fully complete (and no stopping errors) before the stream to output 2 is processed.

GauravRawal

Hi Joe,

That worked perfectly fine. But why didn't the block until done did not help in the above case? My original thought was that this would be doable using product tools, without any external Macro.

GauravRawal

Also, i found a sort of a problem with the working of this upon some more testing.

I was trying to move the source .csv files to some other folder after processing the data(after writing to a snapshot table but before writing the data to the source table). I am doing this via a .batch file in the event section of the work flow. So the flow in a nutshell is:

Read data from CSV files -- Process the data -- Write to a Final Table -- Move the files to some other archive folder -- Write the source data to a source table.

But I found that if this batch file gives an error(which is basically the end of stream 1), the data is still being written to the source table. Is it happening because this is an event, occurring on an external file and Alteryx is not considering it as an error within the flow?

Below is a screenshot of the error:

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335