How do I out formula expressions to an output file? For audit purposes

Question

Hi,

I need to document how I've transformed a data set for audit purposes. What's the best way to copy  the details within a formula tool to an output file e.g. a tab in a worksheet called 'Formula logic'?

I've had a look around the portal and couldn't find a suitable resolution (e.g. I've seen people using screenshots but this isn't conducive of automation)

Thanks in advance

JB

avanbrunt · Answer

I am having this same issue.  I am editing a field twice within one formula tool and the field info tool is only showing me the 2nd formula.  I need to output all formulas within the formula tool.  Has anyone figured out how to do this?

JamesBarzda · Answer

Hi,

I have but, as you can see below, I'm using one formula tool to calculate two columns based on a value within those columns e.g. if invoice number contains 'x' then minus 100 from 'Purchases Net GBP'. As we've got more than one manual adjustment, I've added a formula (Within one tool) to like the below. When I use the field info tool, it only displays the first formula for each column (shown in the second screen shot)

Luke_C · Answer

Hi @JamesBarzda

Have you tried the field info tool?