Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

JamesBarzda
7 - Meteor

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

2 REPLIES 2
Luke_C
17 - Castor

Hi @JamesBarzda 

 

Have you tried the field info tool? 

 

Luke_C_0-1648473961595.png

 

 

JamesBarzda
7 - Meteor

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)

 

 

JamesBarzda_0-1648474617124.png

JamesBarzda_1-1648474796522.png

 

 

Labels