The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Drag a formula onto another formula to combine formula tools


I am just making a quick suggestion, specifically for the Formula tool within Alteryx.


Often when I am working on a larger workflow - I will end up optimising the workflow towards the end. I typically end up removing unnecessary tools, fields, and rethinking my logic.


Much of this optimisation, is also merging formula tools where possible. For instance, if I have 3 formulas - its much cleaner (and I would suspect faster) to have these all within one tool. For instance, a scaled down example:



to this:



This requires a lot of copy and paste - especially if the formulas/column names are long - this can be two copy and pastes, and waiting for tools to load between them, per formula (i do appreciate, this sounds an incredibly small problem to have, but on what I would consider a large workflow, a tool loading can actually take a couple of seconds - and this could burn some time. Additionally, there's always potential problems when it comes to copy/pasting or retyping with errors).


My proposed solution to this, is the ability to drag a formula onto another - very similar to dragging a tool onto a connection. This integration would look like:



Drag to the first formula:









Formula has been appended to the formula tool:




I think this will help people visually optimise their workflows!




17 - Castor
17 - Castor

I'd also like to be able to move (drag) or copy (Ctrl - drag) formulas from one tool to another.

13 - Pulsar

Until this gets implemented, if anyone does have the need to move formulas from one tool to another, copying the XML speeds things up a lot. Not as convenient as just pasting the tool, but until then, it's better than re-creating the fields from scratch!


  1. Go to the formula tool you want to copy FROM, then click the XML View icon in the config pane:

    If you don't see the icon, go to Options --> User Settings --> Edit User Settings --> Advanced tab --> check Display XML in Properties Window

  2. Each field in the formula tool = one FormulaField element (one row in the XML). Select and copy the fields (rows) you want to move over to a different Formula tool.

  3. Go to the formula tool you want to copy TO, then click the XML View icon in the config pane.

  4. Click Edit in the upper right corner.

  5. Paste in the rows you copied (just make sure they're inside the <FormulaFields> </FormulaFields> tags).
    If the calculations you're pasting are dependent on other calculations, you may need to reorder them, but you can do that after step 7.

  6. Click OK

  7. In the config pane, click the gear icon (above the XML icon) to go back to the "normal" view, and you should see the fields you copied.
17 - Castor
17 - Castor

Editing the xml is a great tip and a very cool idea @kelly_gilbert - definitely something to play with! 

15 - Aurora
15 - Aurora

awesome little 'hack', thank you @kelly_gilbert !

Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes
6 - Meteoroid
Status changed to: Under Review