User GuidesAPI ReferenceRelease Notes
Doc HomeHelp CenterLog In

Working with Expressions

An expression operates on zero or more attributes, and can be used in a formula or multiformula, or as part of a statement in a script.

The effect of an expression is highly dependent on how it is used.

Overview

This topic introduces terminology used when working with expressions.

Expressions in Formulas and Scripts

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.

871

An expression in a formula: upper(name).

In a formula, you select the output column from a dropdown list: in this example, name_cleaned.

The following image shows the same expression (surrounded with a blue solid line) in a script.

873

A script with an upper(name) expression and a named expression of upper(name) AS name_cleaned.

When a script includes an output column for the result of the expression, name_cleaned in this example, collectively they are referred to as the named expression (surrounded with a pink dashed line).

Components of Expressions

Expressions can consist of any number of the following components:

  • Functions
  • Column names
  • Literals

The image that follows shows valid expressions in several formulas.

862

Expressions are made up of literals, columns, and functions. Four example formulas are shown with numbers that match the descriptions that follow.

The result of each of these example formulas is:

  • 1 uses the literal 0 to populate the name_cleaned output column.
  • 2 uses the values in the name column to populate the name_cleaned output column.
  • 3 uses the upper function on the name column to make values all uppercase and then uses the result to populate the name_cleaned output column.
  • 4 uses the upper and concat functions on the first and last columns with a literal ' ' (space) between them to make values all uppercase and concatenate the resulting values together and then uses the result to populate the company_name output column.

The topics in this section describe different types of expressions and provide examples of using expressions in context.