Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx Designer Tool: Find and Replace within all tools in Designer

swoodling
7 - Meteor

Is there a way to do a find and replace within all of the tools in a designer workflow? 

 

Example: you had a Dynamic Rename tool at the beginning of the flow that added "INPUT1_" as a prefix on all of the columns and now you want to change it to be "1INPUT" or something different. This will result in all of the subsequent tools breaking since they were setup with "INPUT1_" on all of the columns. THis means you have to manually update every tool to correct this and you end up with a lot of Missing Fields within tools etc. 

3 REPLIES 3
apathetichell
20 - Arcturus

open your alteryx workflow as a .txt file (/0 delimiter) in a another instance of designer. use formula to replace values. output data to /0 text (or change file name to whatever you want). keep at utf-8. save.

 

or do this in notepad.

Mathias_Nielsen
9 - Comet

You can also just add another Dynamic rename tool at the end. Then you won't have to go through the whole workflow and change every tool configuration :)

swoodling
7 - Meteor

Thanks for the solutions. I was able to test both!

Labels
Top Solution Authors