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.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
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.
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 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!