This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I had developed a workflow and packaged it into an analytic application. To ensure accuracy, I also included several validation checks into the workflow, which would notify users if some validation rules fail. I achieved this using several Message tools.
The challenge which I'm facing is that after people run the app, they have to click on the 'Output Log' button (dummy screenshot below) to find out which validation rules failed, which causes an issue as sometimes people forget to do that and this is an extremely crucial exercise.
Is there a way by which I can make all the validation issues pop out to the users as soon as they run the workflow (like the same way the output pops out in the screen above)? I know one way of achieving this is to set the Message tool to output errors (like in the screenshot below), but I prefer not to do that as users will only see errors one at a time, vs setting it as Warnings or Message where they can see all the issues in one shot.
Does anyone know if there's a more elegant way of handling this?
You can use a technique like this to show validation messages to the user in an analytic app. It doesn't use the message tool, but instead builds a validation data frame to show to the user if required
The validation container uses one filter/formula tool pair for each validation you want to apply, with the filter applying the validation rule and the formula adding a rule name column. After the join/union combo you end up with all the validation results for the rows that fail, like this
When you run this as an analytic app, you get one of the following 2 outputs
If there are no validation errors, you get only the Output Files tab visible in the results window
If there are errors, a Validation Output Tab is visible in the results window. Selecting it show the results of the validations
You still need to train the user to look for the Validation Output tab in the results, but it gives a visual cue to the user when there are errors and presents only the errors so the user doesn't need to scroll through the entire output log to see if there any messages
Yeah I believe your way of going about it is much better because it comes out as a separate tab and it eliminates all the other unnecessary log messages. Only issue is that there are over 50 validations so it would require a bit of work to set that up haha :D. But I would rather do it your way for sure.
I also realized I can write custom output messages from the Interface Designer section. I'm thinking I'll also use that to consciously remind the user to have a look at the validation tab.
There's no easy way to use the output in the same workflow(target wf) that you're trying to analyze, but using the AlteryxRunner(AR) does output what you're looking for. Just built the analysis portion using the output of the Run Command tool. With this setup, the workflow that is regularly run/scheduled is the AR workflow and not the the target wf being analyzed. That way the target is only run once.
btw... As opposed to using AR in a Run Command tool, I would use the CReW Runner macro instead. It makes for a more portable workflow since the Runner takes care of finding the AR executable file and has separate outputs for successes and failures.
Attached is an example. The CReW Runner macro just wraps the AR executable and produces 2 outputs for success and failure
The log is contained in [Log] field. You'll have to split to rows using \n as the delimiter to get the same format as the output of AR.
As far as Gallery is concerned, you can't use the Runner macro on the Alteryx Public gallery, but you can on your own private gallery server.
When Alteryx says that theCReW runner macros are notsupportedon the gallery, what they're saying is that if you use one of the runner macros in a workflow. they'll only help out in a support case if the workflow is running in Designer. If the workflow is running on a server then you're on your own. You can always turn to the Community for help.
I haven't found a case where they say that the runner macros are not "recommended" on the gallery, only that they're not supported. I've used the runner macros on our private gallery in the past with no issues
I am trying to use CReW Conditional runner macro within Gallery. But getting error due to my requirements.
Workflow perform some validations, if error workflow will stop. If there is no error the results of 1st workflow will store in Intermediate folder (relative path).
if first workflow is successfully run, 2nd will will read files from Intermediate folder and perform the task and store the files in the output folder.
I have placed both the workflow in conditional runner with log parser for both anchor to parse the messages/error. I am getting error while executing this workflow in Gallery saying cannot access intermediate folder.
If I try to execute the same set of workflows with chain of apps its working fine, but I need to use conditional runner macro with log parser to parse the log and send log information to user.