Easier Selection of Fields in Expression Builder

[cbridges]

I've found that double-clicking in the expression builder results in varying behavior (possibly due to field names with spaces?)

It would be great if double-clicking a field selected everything from bracket to bracket inclusive, making it simpler to replace one field with another.

For instance:

Current:

IF [AVG AGE] >=5 THEN "Y" ELSE "N" ENDIF

Desired:

IF [AVG AGE] >=5 THEN "Y" ELSE "N" ENDIF

[GarthM]

hi @cbridges,

this expression is already available. it's the IIF(bool, x, y) conditional expression.

for example, your scenario that looks like this:

IF [AVG AGE] >= 5 THEN "Y" ELSE "N" ENDIF 

can be written like this:

IIF([AVG AGE] >= 5, "Y", "N")

that said, i agree that the variable selection could be improved. i'd also like to see an option for a global replace of a variable name in the case of lengthy IF/ELSE expressions.

[cbridges]

Hi @GarthM - I hadn't paid full attention to your response previously, sorry.

What I'm talking about is not the formula, it's the behavior of the interface when I double-click inside a formula, and what characters are included in the selection.

It's hard to see what I'm talking about in the original post without color. What I mean is this:

Right now, double-clicking selects only "AGE]" in the formula below, whereas I think it's more intuitive for it to select "[AVG AGE]" (the entire field name).

IF [AVG AGE] >=5 THEN "Y" ELSE "N" ENDIF

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!