How to use Notepad to change the file path for all inputs and outputs at one time?

I am looking to design a new workflow from a copy of another workflow without updating any of the old workflow input or outputs.

I was thinking I could export the WorkFlow xml path, so I can update all the file input/output paths in Notepad with a find edit and replace without manually changing each path reference (e.g., t:/Active/.... to t:/2017/....)

Once I become more proficient I will learn more advanced techniques to design the workflows better to avoid this issue.

Thanks for any tips to get me started on how to export, I tried Options / Export Workflow / and open the .yxzp file in Notepad but no luck. I was hoping than to figure out how to have that new path connected to a copy of the original workflow.

Workflow

Input

Output

Preparation

Accepted answers

CharlieS

I don't think you need to export your workflows, just edit them in a different way.

Manually:

- Browse to the folder where your workflow is saved.

- Right-click on the workflow (.yxmd/.yxmc/.yxwz/etc.) and select Open With > Notepad

- Use Notepad to find and replace the path.

In Alteryx:

- See attached example to parse the XML of a module, replace the path, then save the new module.

- Take caution with tools like this because it makes it easy to change a lot of things very quickly but also makes it easy to break a lot of things very quickly.

XML Edit and Save.yxmd

All comments

CharlieS

I don't think you need to export your workflows, just edit them in a different way.

Manually:

- Browse to the folder where your workflow is saved.

- Right-click on the workflow (.yxmd/.yxmc/.yxwz/etc.) and select Open With > Notepad

- Use Notepad to find and replace the path.

In Alteryx:

- See attached example to parse the XML of a module, replace the path, then save the new module.

- Take caution with tools like this because it makes it easy to change a lot of things very quickly but also makes it easy to break a lot of things very quickly.

XML Edit and Save.yxmd

JagdeeshN

Hi,

If you are looking to just update the file paths, one way to do it is using relative path. Then whichever folder you save the workflow on and run, the input and output files will be taken from that folder.

If you are looking to change input data connections, please try using the aliases. This will enable you to change the input string without making indvidual changes in the workflow.

Best,

Jagdeesh Narayanan

PNau

Charlie,

I just tried the manual approach, exactly my skill level, worked to a T. I just had to remember to copy my workflow, create the new path in my network drive and subfolders in advance. Saved the file and re-ran it.

I will definitely try your second approach another day as it will help me learn faster.

Much appreciated.

Patrick

PNau

Jagdeesh,

Thank you, I will definitely try this approach too as it will also help me learn. I will let you know success or fail...might be a couple of weeks before I advance this far!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703