Hello,
I have activated the performance tracking feature on a workflow. I see the general tabulation of performance in the Alteryx workflow in the results. It is helpful but I was hoping to get access to the information myself without having to copy and paste the information. I parse it out using the colons and the comma which then allows me to create a performance report.
Is there anyway to bypass the copy paste process and to get access to this in formatted or even unformatted way prior to its result sharing? Has someone maybe created a macro already that does this? Any help would be greatly appreciated?
Solved! Go to Solution.
Use the crew macros to parse the log!
Option 1: There is a logfile generated for each working run and a variable you can use to find it. This way can work but requires extra steps.
Option 2: (Easy) Use a Crew macro Runner and a LogParser on the Success and/or Failure anchors to put the log data into table format that can then be read and processed. So create your business workflow as needed and turn on performance profiling. Create a second workflow with those two tools and get the log output into an alteryx table file format. You can then separate it from your business wf and reuse that code on the next project or add an input to ask you which wf to run.
Thank you for your response.
where would I get access to the Crew Macro? Also is there particular version of Alteryx that this would work with?
There might be some kind of corporate by law that keeps me from using the Crew Macro. If I wanted to tap into that log where would I find that log file?
The crew macro is basically a zip file of workflows/macros. Search it out and you'll find the link. I had the same reservations. I believe they give pretty good instructions on how to download and install it. Very easy.
The place I believe the files are written can be found using [Engine.TempFilePath] in a formula tool to at least get you to the name and path of where the output is going.
So to confirm this is the file?
What would be your recommendation in regards to opening and actually using it if you have any? The dynamic input tool is not working it says it needs a template.