The effect of an expression is highly dependent on how it is used.
This topic introduces terminology used when working with expressions.
The following image shows the expression in a formula (surrounded with a blue solid line). This expression consists of a function,
upper(), and the attribute or column you want to apply it to, name.
In a formula, you select the output column from a dropdown list.
The following image shows the same expression in a script (surrounded with a blue solid line).
When a script includes an output column for the result of the expression, namecleaned in this example, collectively they are referred to as the _named expression (surrounded with a pink dashed line).
Expressions can consist of any number of the following components:
- Column names
The image that follows shows valid expressions in several formulas.
The result of each of these example formulas is:
- 1 uses the literal
0to populate the
- 2 uses the values in the
namecolumn to populate the
- 3 makes the values in the
namecolumn uppercase and then uses the result to populate the
- 4 makes the values in the
lastcolumns uppercase, concatenates the resulting values together with a literal
' '(space) between them, and then uses the result to populate the
This topics in this section describe different types of expressions and provide examples of using expressions in context.
Updated about a year ago
|Using Logical Comparators|
|Working with Dates|
|Working with Regular Expressions|
|Map, Filter, and Reduce|