Alteryx designer Discussions

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

Change one item in countless tools

Highlighted
Asteroid

Experts - 

 

Let's say I have a workflow with lots and lots of tools, and many of those tools reference a field named "product".  This referencing can be in formulas, multi row formulas, select tools and so on.  Now our source data has changed for some reason and "product" has been renamed to "product_2".  Is there a way to quickly change every "product" reference to "product_2" without manually checking every tool, or running the workflow and seeing which tools error out?

 

Can this be done via editing the .yxmd html or something?

Alteryx Certified Partner
Alteryx Certified Partner

Use a Select tool at the beginning to rename the new "product_2" field to the original "product" name the rest of the workflow is expecting. If this is an Analytic App, On the File Browse interface tool, select the "Generate Field Map for Input Data Tool" option so the user is forced to assign the field names of their new file to the field names the workflow is expecting.

 

It is possible to Find and Replace the "product" to "product_2" in the workflow XML in a text editor, but it's often very risky in case that string is used in other ways. 

Highlighted
Asteroid

Sorry I should have mentioned part of the requirement is to put the new field name in all the related tools for development purposes, which rules out the select tool switcharoo method (although that would make things much easier!).

 

In this case is doing a find/replace via text editor the only option besides manually updating each tool?

 

Thanks again!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

The 2019.4 Designer release provides you the enhanced Find experience (Ctrl+F) in Designer so you can easily find all instances of the field, but it's still up to you to make any changes. 

Highlighted
Asteroid

Can you leverage the Select Tool at the beginning of your workflow to change Product_2 to Product, then another at the end of your flow to change it back to Product_2? This way you can minimize your time and still meet the requirements of including the field name for dev purposes?

Labels