Performance testing Alteryx workflows

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?

Macros

Accepted answers

dougperez

Use the crew macros to parse the log!

dataguyW

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.

output to log.PNG

All comments

dougperez

Use the crew macros to parse the log!

dataguyW

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.

output to log.PNG

AmirSems_charter

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?

AmirSems_charter

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?

dataguyW

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.

AmirSems_charter

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703