How to locate Alteryx from Excel

CBX

I recently took over some processes for a colleague that exited our company. There is an excel file output from an Alteryx query, that I need to update. However, I don't know where the query is on our shared drives that generates the excel output. Is there anyway to see, using the excel output, the location of the query that generated the output?

Thanks!

CharlieS

The general idea is that you're going to use Directory tools to bring in .yxmd, yxmc, and yxwz files, use a Dynamic Input to open those file as text, and then search that text for the file name. This is often referred to as "XML parsing" because the text form of Alteryx workflows is in XML format.

There's a few important settings on the Input tool to read the workflows:

- Read as delimited text, with a custom delimiter of "\0" (which means "no delimiter")

- Pump up the field width to something like 9999+

- Include the file name in the output so results can be compiled later.

- Deselect "First Field Contains Field Names"

I've put together the attached example to get your started. Just update the three Directory tools to the folder/drive where it lives and the Filter tool to the file you're looking for. 

20200124-WorkflowXMLSearch.yxmd