Copying formulas from one formula tool to the other

Question

Hello! hoping someone might have a way around this. I have a set of formulas done in one Formula tool to add in new columns.

Now I need to replicate all these formulas to existing formula tools in my workflow. What would be the best way for doing this?

Prometheus · Answer

Here's the before, where I have my original Formula tool with two expressions in it and two other formulas tools with just text in them -- Test1 and Test2. I saved it and then went to the file location in my folder and right-clicked it. Then I selected "Edit with Notepad++." Once I had it open I clicked on Ctrl-F to bring up the Find window. I entered the word "formula" in the search bar and clicked on "Find All in Current Document." Notepad++ opens up a window at the bottom with my search results. What I was looking for was this: These are the two expressions I want to keep and copy to my other Formula tools. Then I pasted it to replace . And then pasted it again to replace . Then I saved the file with a different version number so I didn't overwrite my original file. As you can see, both new Formula tools have both expressions in them now. This may be the long way, though. You could just update the XML in the workflow: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Copying-of-formulas/td-p/915412.

Prometheus · Answer

Here's the before shot, where I have two expression in my original Formula tool and two test Formula tools with just text in them. After I saved, right-click on the file and click on "Edit with Notepad++". Click on Ctrl-F then click on "Find All in Current Document," so you can search for the word "formula" wherever it exists in the file. This is what I found: What I was looking for was the formula I wanted to copy. This is it: So I copied and pasted the two middle lines to replace "" and "" then saved it with a new version number and with the file extension .yxmd. When I opened the new file in Designer, I can then see my original Formula tool unchanged and now my two others have the formulas I copied and pasted into them from Notepad++. **Be careful, though. Don't overwrite the original file in case you make a mistake.

KamenRider · Answer

Please expand by citing examples and screenshots.

Thanks,

Kamen