This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
Hi all,
Since I have quite a large number of workflows running regular, sometimes, I might lose track of which workflows created which YXDB files.
I would like ask if, given a YXDB file, it is possible to find out the name/directory of the workflow created it?
One method I could think of is to output the name/directory of the current workflow as a new field in the YXDB files. But it is still not an ideal solution as I have to add this new column every time when I am exporting a YXDB file.
Any thoughts?
Thanks,
Jasper
Solved! Go to Solution.
Hi Jasper
Here are some ideas:
1) Embed a code in each YXDB file name that can be indexed back to the source workflow.
2) Add an OUTPUT DATA tool to your workflow that appends to a log of YXDB file creation events with the time, date, file name and workflow name.
3) Place the workflow name or identifier in a user constant, use the FORMULA tool to add a column with the user constant as the value and then output the YXDB file with the constant as the suffix. If you uncheck the box [Keep Field in Output] then the column is not in the output.
I'd actually create a workflow to do this.
Workflow XML is relatively straight forward to parse and there is a small example of how you can input and work with workflow XML within the sample workflows.
Sample Workflows > Use Scripting and Automation Tools > Build a macro > Identify tools and macro's used in a workflow.
Someone else asked a very similar question recently and my colleague has built out a sample workflow solution to find all the input and output files given a directory with a series of workflows.
You'd have to come up with some methodology to getting the workflow files from the Alteryx Server but that's definitely possible.
Ben
Hi @derekbelyea and @BenMoss, thanks for the solutions!
I was actually hoping there are some sort of meta-data within the YXDB file for us to easily check which workflow created it. However, I believe this is not yet available in the latest Alteryx version. But the solutions proposed by you are nice too anyway. Thanks!
Jasper