Alteryx Designer Desktop Discussions

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

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. 

2 REPLIES 2
apathetichell
19 - Altair

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
6 - Meteoroid

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 :)

Labels