Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.

What tools would YOU refresh with the new expression editor?

LeahK
Alteryx Alumni (Retired)

 

tools.gifWhen we released the new formula tool in 11.0, everyone was wondering when the filter tool was going to have the new expression editor, which got me thinking…

 

There are many tools that use the expression editor, some in the default configuration and some in a dialogue box.

 

GOT THOUGHTS_extra small.pngIf it were up to you, what three tools would you refresh with the new expression editor?

 

 

We’d love to hear your thoughts! Feel free to include as much or as little information as you like.

21 REPLIES 21
jdunkerley79
ACE Emeritus
ACE Emeritus

I'd do:

 

1. Filter

2. Multi-Row

3. Multi-Field 

 

(plus make the CodeEditor easier to embed ourselved in JS HTML SDK and then the community can build our own replacement UIs to help out ...)

mceleavey
17 - Castor
17 - Castor

I would definitely put at the top of the list those tools that are natural brethren to the formula tool, such as the multi-row and multi-field formula tools. This is currently quite a jarring shift when stepping from the new to the old, so this is where I would definitely start.

This functionality would also be a natural fit for the dynamic tools, specifically rename and select.

 

Currently, the older (mature? Experienced? Aged like a fine wine?) users will be comfortable with the old expression editor, but it may be confusing for new users.

 

 

 



Bulien

RachelW
Alteryx Alumni (Retired)

@Philip Are you referring to these options under the variable tab?

 

MultiRow.png

 

With the expression editor in Formula, we put all of the variables under the variables (X) button. If we did that with the negative and positive indexing, would that work for you?

 

 

 

 

 

Rachel Wynn
Product Manager - Designer
RachelW
Alteryx Alumni (Retired)

I'm blown away by all of your feedback! I'm so glad that so many of you have interest and thoughts on the new expression editor. I'm actively trying to figure out how we can get the new expression editor into more tools. Thanks again for your feedback. 

 

@DultonM and @JohnJPS I'd love to take a look at some of the crazy expressions you are building for the Action tool. 

Rachel Wynn
Product Manager - Designer
JohnJPS
15 - Aurora

@RachelW

 

Hi Rachel, in the final analysis they don't look too bad, but I know as I'm doing "Replace with Formula", or especially "Replace Raw XML with Formula" it gets a little tedious with a lot of nested Replacements.

 

Spoiler
scrnshot01.png

scrnshot02.png

 

 

Philip
12 - Quasar

Hi @RachelW

 

Yes, those are the options I was referring to.

 

That might work, but depends on how the recommendations pop up in the suggestions and the variable tab. For example, I have created Multi-Row lookups up to 7 days back. That means each field would multiply by 7. And if I have fields of Test Date, Test Type, Test Interpretation, ant Test Result, typing "test" would pop up 4 fields * (7 negative & 7 positive) = 56 suggestions populating the variable list and the suggestion list to choose from. Typing "interpretation" wouldn't be any better because I have several fields with interpretation in them.

 

Then there would be the ordering. Would suggestions order by field, by Row-offset, or how?

 

Maybe I just have an outside case, but this was the situation I was referring to.

 

Having the Variable tab as you show withing the variables X button would solve the problem there. It would just require the user to ignore the overwhelming number of suggestions in the example above.

SeanAdams
17 - Castor
17 - Castor

:-) great question - and it's a fantastic idea to use the community to help figure out where people's priorities would lie @LeahK

 

I agree with most of the other folk, and @TaraM 's alteryx periodic table bears this out too.  

The most commonly used tools, that would benefit from up uplift (in order of usage) are:

  • Filter
  • Multi-field formula
  • Multi-row formula

In addition, there would be two additional requests I'd throw in:

- There's very little that will cause emotional harm as quickly as a super-long formula written by an enthusiastic amateur with no decent indenting to figure out what it's trying to do.   Any chance you could offer the ability in your new editor to pretty print a formula (example below)

- the editor still punches out to the help text related to the formula tool, instead of going straight through to the help for the function I'm working on.    If we could make this contextual it will save a google search every time we use a date time function (time spent looking up those % character codes).

 

Thanks for the opportunity to contribute to this discussion!

 

Sean 

 

 Example:

if X then Y else if A then B else C endif endif

 

should be come

if X

then Y

else

    if A 

    Then B

    Else C

    Endif

endif

JohnJPS
15 - Aurora

Great point on indentation @SeanAdams.   I would even add one more small step and keep all the If/Then/Else/EndIf syntax segregated from the rest:

 

If (X) Then
   Y
Else
If (A) Then B
Else
C EndIf
EndIf

 

i.e. the "results" (either Y or B or C) are all on their own line; for me this is easiest to read; I'm also in the habit of surrounding my conditions in parentheses, although that serves no purpose other than said habit. :-)

SeanAdams
17 - Castor
17 - Castor

:-) @JohnJPS  what's funny is that this is how I had originally mocked it up, but then felt too geeky and backed it back.

Personally I'm one of those sad types that even indents function parameters if there's more than 2 :-)

gnans19
11 - Bolide

1. Filter

2. Multi-Row

3. Multi-Field

 

 

Labels