General Discussions

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.

What tools would YOU refresh with the new expression editor?

Highlighted
16 - Nebula
16 - Nebula

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 ...)

Highlighted
Alteryx Certified Partner

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.

 

 

 

Highlighted
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
Highlighted
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
Highlighted
ACE Emeritus
ACE Emeritus

@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

 

 

Highlighted
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.

Highlighted
16 - Nebula
16 - Nebula

:-) 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

Highlighted
ACE Emeritus
ACE Emeritus

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. :-)

Highlighted
16 - Nebula
16 - Nebula

:-) @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 :-)

Highlighted
Alteryx Certified Partner

1. Filter

2. Multi-Row

3. Multi-Field