See image of workflow snippet below. Can't really attach workflow and can't really fake it since it needs XML to parse.
#A (first parse tool) Parse Tool. It will generate NEW_FIELD_OuterXML -- if it is present (it may not always be present).
#B (the filter tool immediately after the parse tool -- and with the error badge in the image) Filter Tool checks to see if NEW_FIELD_OuterXML is present; if True then it sends the record(s) to be parsed.
What I have tried so far:
QUESTION: How can you halt, detour, ignore a section of a workflow if a field is not present -- and do so without throwing errors?
WORKFLOW IMAGE
Brute Force w/ Ensure Fields (6 more not visible)
Hey @hellyars
There are Detour tools that are great for only passing data to tools of the active route (and the other tools won't error if they're missing a field). The detour control comes from a checkbox on the tool UI. However, since the decision to detour or not is coming from the data stream, you'll need to take a few more step to make this happen.
This is called a "Dynamic Detour" (when the decision is based on the data stream). My preferred method is to use a batch macro. Insert the detour tools in your workflow, then take that section and save it as a batch macro with the Control Parameter updating the detour. Then when you re-insert that into your workflow, dynamically determine if you need to detour and use that to update the Control Parameter.
Here's another good link to check out on dynamic workflows:
https://www.altertricks.com/expert/building-dynamic-workflows-with-detour-tools-or-updating-xml/
Will this work if used in Alteryx Server and not Designer. I tried using Message Tool, Error Tool, Test Tool and all three doesn't work on the server. An error still shows even when the condition to trigger the error is not met.