Last modified: September 24, 2020

Use functions to build expressions that perform a variety of calculations and operations. 

Types of Functions

These function types are available for transforming your data. The type of data determines the functions you can use. Visit Data Types for more information.


Conditional functions allow you to perform an action or calculation using an IF statement. Learn more in the Conditional Functions article.


Conversion functions convert numbers to strings or strings to numbers. Learn more in the Conversion Functions article.


DateTime functions allow you to perform an action or calculation on a date and time value. Learn more in the DateTime Functions article.


A file function builds file paths, checks to see if a file exists, or extracts a part of a file path. Learn more in the File Functions article.


A finance function applies financial algorithms or mathematical calculations. Learn more in the Finance Functions article.


A math function performs mathematical calculations. Learn more in the Math Functions article.

Math: Bitwise

A bitwise function operates on one or more bit patterns or binary numerals at the level of their individual bits. Use a bitwise function to manipulate values for comparisons and calculations. Learn more in the Math:Bitwise Functions article.


A minimum or maximum function finds the smallest and largest value of a set of values. Learn more in the Min/Max Functions article.


An operator is a character that represents an action. Use an arithmetic operator to perform mathematical calculations or a Boolean operator to work with true/false values. Learn more in the Operators article.


A spatial function builds spatial objects, analyzes spatial data, and returns metrics from spatial fields. Learn more in the Spatial Functions article.


These functions perform a variety of specialized actions and can be used with all data types. Learn more in the Specialized Functions article.


A string function performs operations on text data. Use a string function to cleanse data, convert data to a different format or case, compute metrics about the data, or perform other manipulations. Learn more in the String Functions article.


A test function performs data comparisons. Use a test function to identify the data type of a value, or determine if a value exists. Learn more in the Test Functions article.

Expression Editor

Functions can be built within the expression editor.

Build an Expression

Use any of these methods to build an expression:

  • Enter the function directly in the expression editor.
  • Select the Columns and Constants button to browse through variables that can be used in the expression. Select the variable to add it to the expression editor.

Syntax Highlighting

As you edit the expression, the editor applies a color-coding scheme to its various parts to make the parts of the expression easy to distinguish. For example, functions are gold, variables are fuchsia, operators are magenta, and strings are turquoise, a blue-green.


Select Functions to browse through categories of functions. Select the function to add it to the expression editor.

Columns and Constants

Select Columns and Constants to browse data from incoming connections and global variables.

  • Existing Columns: Data from an incoming connection, or from a column created in a previous expression.
  • Connections from Questions: Values from an Interface tool connected to the Question anchor of a tool with an expression editor, when the tool is used in an app or macro. Use the Question anchor when you want question values to be used as variables in the expression. Visit Interface Tools for more information.
  • Constants: Global variables for a workflow that make it possible to change a value in a single location and have that change apply to the rest of the workflow. Visit Constants for more information.

Recent and Saved Expressions

Select Recent and Saved Expressions to browse through recent and saved expressions. Select the expression to add it to the expression editor.

Save an Expression

  • With an expression in the expression editor, select Save.
  • Enter a name for the expression and select OK.

Tools with Expression Editor

These tools include an expression editor. Tools that use an expression editor have an additional Input anchor and Question anchor when the tool is used in an app or macro workflow. Use the Interface tools to connect to a Question anchor when you want question values to be used as variables in the expression. Visit Interface Tools for more information.

Action Tool Icon

Action Tool

Condition Tool Icon

Condition Tool

Error Message Tool Icon

Error Message Tool

Dynamic Rename tool

Dynamic Rename Tool

Filter Tool Icon

Filter Tool

Beaker with bubbling liquid

Formula Tool

Box with rows, a plus sign and an arrow pointing downward.

Generate Rows Tool

Beaker with liquid and stir-stick.

Multi-Field Formula Tool

Liquid drops falling into a beaker.

Multi-Row Formula Tool

Interactive Chart Tool

Interactive Chart Tool

Orange polygon containing globe.

Report Map Tool

Orange polygon with white table with multiple rows.

Table Tool

Message tool

Message Tool

Test Tool

Test Tool

Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.