How to identify unused fields

Question

Hi,

I have inherited a workflow which pulls data from a very wide data source (200+ fields). Currently, most of these fields are brought the entire way through the workflow despite not being required as part of the output or not used at all during the workflow.

Is there a way to identify these so that I can remove fields as early in the workflow as possible?

My only thinking at the moment is using the Field Info tool and comparing but unfortunately there are also a lot of renames (multiple times) within the workflow also.

Thanks

aoxomoxoa · Answer

i have a need for this as well -- has it been taken into consideration ?

to identify fields not used within a workflow at all

EnglishmaninNY · Answer

how do I upvote this more?

I'm thinking there should be a button on certain tools (those with a list of the field contained). The button will cause an analysis of dependencies. I'm sure it will get more complex as you dig into it but for my typical use case I'm thinking two columns with a count which you can click to see detail:

- Column 1 - Count of use in prior join tool(s)

- Column 2 - Count of use in prior formula tool(s)

If it does fit in either of these buckets it feels like its just data which is flowing through but will not impact the selection of records you end up with.

What I find really frustrating is that if you input changes then any new fields just litter the whole workflow and without know which will have a material impact you have to track through all the tools to figure out where/if it is used. Or is there a trick to make this easier?

markcurry · Answer

Gotcha, sounds like a tricky one so.  Hopefully someone has a workflow that reads the workflow XML, and can identify the fields that tools like the formula tool use during the workflow.