Workflow Dependencies

Question

Hi, I would like to be able to get a list of workflow dependencies into .xlsx or .csv for all workflows saved in a given directory.

Using directory tool and a macro I have tried reading in each workflow in sequence as a csv which gets us the xml and I have been able to pick out certain strings which I believe to be all inputs and outputs however I feel my method here is quite messy and I cant prove if its doing the job 100% of the time.

Given that dependencies can be viewed via the options i was hoping someone out there may know of a way to extract the dependencies(inputs and outputs) easier than the method I have embarked on above.

I think the answer lies in the XML if anyone knows the answer please help!

Felipe_Ribeir0 · Answer

If you have access to the workflow logs, it is possible through there too. They keep the information about all the used inputs/outputs of the workflow execution.

I did a similar job parsing the txt logs using this workflow: https://community.alteryx.com/t5/Community-Gallery/Parse-Alteryx-Log-Files/ta-p/999093

gabrielvilella · Answer

You are on the right path, you need to read that information from the XML. It can look messy, but it is the only way.