How to detect if any one of multiple flows had an error?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Labels:
- Common Use Cases
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
 
