Workflow Formula Auditability

Hi All --

One of the things that the people in my Tax department really like abut Excel is that they can click in a cell and see the formula that generated the result they are looking at.

Usually, then I provide an Alteryx output they can't necessarily see how I got to a number. I then need to show them the workflow and walk them through it.

Is there a way that I can pull the formulas out of the XML? I'm thinking of dropping them in as columns, so they have the trail. This becomes important when providing this information to our external auditors.

I searched online but couldn't find anything about it.

As always, thank you for your help!

Regards,

Seth

Preparation

Expression

Accepted answers

danilang

Hi @smoskowitz

You can input the .yxmd of your workflow as a .csv with \n as the delimiter. This will load the entire file with one line per record. Add a mulitrow to copy down the Tool id and then a filter to extract the rows you're looking for.