Outputted Field Data Mapping

[Alayna]

I want to create some more documentation around a couple large reports created from workflows. Can anyone recommend a solution or macro that could look at the outputs of an Alteryx workflow (mostly Excel) and output the list of fields and their sources? For example, Field 1 is from an input file, Field 2 is from a SQL query, Field 3 is a calculated field. A data map such as this would help a lot in troubleshooting and answering client questions.

[kboeckholt · Accepted solution]

Hi @Alayna 

Have you tried using Field Info tool? This will provide Name, Type, Size, Scale, Source, and Description for each field.

[Alayna]

@kboeckholt I completely forgot about that tool. Thanks!