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!
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.
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
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |