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'm brand new to Alteryx after a stint in SQL development. My question is this: I will be working to create error reports based on nightly workflows, and I could use some advice on how to best send error/conversion messages to an external file. This file would ideally be part of an existing workflow, and would be emailed automatically to specific recipients. I know how to create a report, and how to email it. My stumbling block is how to export the error messages into the report. I would appreciate any help.
Check out the Events available on the Workflow Configuration window. One of the events you can configure is to send an email after the workflow has finished running that contains the output log of that workflow.
I've seen the Invisio macros for email. I need to investigate them further, but they initially don't strike me as being that intuitive to set up. I've made use of building out a simple process using SendEmail that is working.
The issue with using the logs is that a log for a currently running process is blank until the process actually completes (including any "rear end" tools like the Email tool or macros, and events), which means that you can't get the log from a process "within" the workflow.
I'm going down the road of creating a scheduled process that runs on a frequent basis that pulls all of the logs for a given time period and then determines (based on key words) whether a workflow that recently ran is considered an "exception" and needs to be reviewed.
At this point that's my best idea. If you can think of anything better, would appreciate your insights!