This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
1. Multi-Row Formula 2. Multi-Field Formula 3. Generate Rows Tool
Reasoning for all 3 is basically the same - if I like using the new expression editor on one formula at a time, then I will LOVE using it on formulas that do many things at one time!! Especially the Multi-Row tool... when you start getting into long formulas with multiple references to other rows and fields, would be SO helpful to just start typing the field I want, and then be able to pick whether I want it from the current row, previous row, etc.
How can I vote for options other than those of @NicoleJohnson? I insert a new tool and reorder some of the same tools.
2. Multi-Field Formula
3. Multi-Row Formula
I used an Alteryx Easter egg to go old-school on the tools. As you can see, the Filter tool deserves a little TLC as it has been around longer than the Multi tools. Since this is a THURSDAY thought, and Thursday is a Throwback day I encourage others to vote Filter into inclusion in the new expression editor club.
P.S. Do you know how I converted the icons? It is a trick that anyone can do.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
Number one for me, by a mile: Action Tool... from the Interface tab for use in macros... this results in some huge, ugly expressions and it would be really nice to have auto-complete and syntax highlighting there.
Others, also based on my typical expression complexity
For me, my Filters, while ubiquitous, are usually pretty trivial, simple expressions.
I would say no to the Multi-Row Tool first because it would also have to manage the negative and positive indexing. This would make it more difficult to implement cleanly, in my opinion. I'd rather go for the quicker wins.
BTW: Just a quick comment on the new expression editor. When you use a String expression in it, that string turns italic and light green. There's something that bothers me, and is that the pipe ( | ) looks like the slash ( / ) when this happens.
Definitely looking forward to more of the new expression editor! I heard at Inspire that work on the Filter tool is already begun, so excluding that one I'd say...
1) Multi-Row Formula (I use this a lot, and according to the Periodic table of Alteryx tools, a lot of other people do too!)
2) Multi-Field Formula (I use this a lot, and according to the Periodic table of Alteryx tools, a lot of other people do too!)
3) Action (for the same reason @JohnJPS...my most crazy expressions are in Action tools)
4) Dynamic Select
I had to throw the Dynamic Select up there because it's not even listed on the "expression editor" help page even though it has one! Its expression editor is unique due to the options you can pick under Variables --> Fields.