How to detect if any one of multiple flows had an error?

Question

I'm very new to Alteryx so this is probably a simple question, but I haven't found an answer by searching.

I need to ingest several files, perform a variety of error checking on them (different for each file) and then write the files out somewhere different. I'd like to only write the files if none of the files have an error condition.

I've attached a simplified example - in this example the 2nd file fails the error check but both files still get written. My goal is because of the error in the 2nd file, neither of the output nodes will execute.

I know I can set the workflow to stop on errors but that doesn't necessarily prevent the 1st file from being written before the error occurs. If it matters, I will have 10-12 files ingested via this process, I'm using a simple 2-file case to work out the process.

Thanks for any help!

dwstada · Answer

@rogerglogowski you can do this nicely with control containers, I have attached an example workflow - just do this for each file/output you want to separate from each other

rogerglogowski.yxmd

OTrieger · Answer

@rogerglogowski

Do the error test for each of the files, so you have one thing that will indicate if data is correct or not. Get all of these test merge together so you can do a condition on all the data if correct or not.

From this point there are many ways how to get it done. I would use Batch Macro, to enable or disable a Container in it with all the output data tool.

So based on correct the Container will be enabled and data will be written out, if there is an error the Container will be disabled and then no file will be written out.