File Output

[johnrexrima_19]

Hello,

My workflow has a couple of formulas in different columns. Will I be able to retain those formulas in the output file?

Thank you!

[TomWelgemoed · Accepted solution]

Hi @johnrexrima_19 ,

Not sure whether you mean the results of the formula or the formula itself, but I've assumed the latter. 

It's not actually easy to keep the formulas (logic/metadata) in the output - you could of course hard code this into another field, but it's not a dynamic addition to the best of my knowledge. The only way I can figure how you could read this information is by adding a data profile tool to your workflow to be able to see what the field is doing. You can then filter on the type of Source and extract the formula and join it back to your fields.

I'm attaching an example. Let me know if this is not what you were after.

Cheers,

Tom

[johnrexrima_19]

Hi @TomWelgemoed ,

Yes, I wanted to keep the formula itself in the output file. Thank you for your help!

[TomWelgemoed]

Ah, great to hear - have a nice day.