Alteryx Designer Ideas

Share your Designer 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

Hello!

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:

TheOC_0-1638886556192.png

 

to this:

TheOC_1-1638886598494.png

 

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:

TheOC_4-1638886826166.png

 

Drag to the first formula:

 

TheOC_5-1638886837420.png

 

 

Release:

 

TheOC_6-1638886865299.png

 

Formula has been appended to the formula tool:

TheOC_7-1638886879753.png

 

 

I think this will help people visually optimise their workflows!

Cheers,
TheOC

 

 

8 Comments
CristonS
Alteryx Community Team
Alteryx Community Team

hey @TheOC, this is a cool idea! I can't begin to estimate the time/ effort of implementing, but it sure would be a neat trick. Thanks for posting!

TheOC
13 - Pulsar

@CristonS 
I did think this - definitely me being a pain for suggesting this!

I cant think of any other tool/functionality similar, apart from dragging a tool into a connection.


CristonS
Alteryx Community Team
Alteryx Community Team

Maybe it'll be easier in the Cloud version? It's worth passing along : )

Thableaus
17 - Castor
17 - Castor

I like this idea. It could be considered along with enhancements to make the Expression Editor more dynamic in other tools like Multi-Row Formula, Message Tool, Multi-Field and so on...

gtaramasso
7 - Meteor

I've had many occasions where this functionality would be useful. Instead of drag and drop, I would also take "select two formula tools, right-click and select "Merge".

 

eh-hem....While I'm here, along the same lines, I'd like to plug the idea of *swapping* two tools; this falls into the same category of optimizing a workflow after you've written a first draft: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Select-Two-Consecutive-Tools-and-Swap-Order/...

CristonS
Alteryx Community Team
Alteryx Community Team

Whaaa? Swap tools? That is such a cool idea! (Also your merge idea is cool too!) Thanks for posting.

DawnDuong
12 - Quasar
12 - Quasar

Actually it would be cool to have the opposite functionality as well. I.e. the ability to right-click a Formula Tool to split a "compounded" formula tool into different "single" ones.

So the ability to "group" / "ungroup" formulae would be really cool.

DanielG
10 - Fireball

This would be a great enhancement.  (Drag and Drop as well as right-click merge)  When I go back into an old workflow of mine from back when I first started using Alteryx, I often say to myself, "What the hell was I thinking with 5-6 formula tools in a row???"  🙂