Page tree

Alteryx Analytics Cloud


Our documentation site is moving!

For up-to-date documentation of the Alteryx Analytics Cloud platform and applications, please visit us at

We no longer update the content for the Analytics Cloud products on this site.


View a list of all tools in Designer Cloud. Tools are grouped according to their tool categories.

Workflow In-Out Tools

Input Data Tool Use Input Data to connect to a table to pull data into your workflow.
Output Data Tool Use Output Data to write results of a workflow to supported file types or data sources.
Text Input Tool Use Text Input to manually enter text to create small data files for input. This can be useful in testing and creating Lookup tables while you build your workflow.

Workflow Data Preparation Tools

Data Cleansing Tool Use Data Cleansing to fix common data quality issues. You can replace null values, remove punctuation, modify capitalization, and more.
Filter Tool Use Filter to select data using a condition. 
Formula Tool Use Formula to create new columns, update columns, and use 1 or more expressions to perform a variety of calculations and operations.
Row ID Tool Use Row ID to create a new column in the data and assign a unique identifier, which increments sequentially for each row in the data.
Sample Tool Use Sample to limit the data stream to a specified number, percentage, or random set of rows. In addition, the Sample tool applies the selected configuration to the columns you want to group by.
Select Rows Tool Use Select Rows to return rows and ranges of rows that are specified, including discontinuous ranges of rows. This tool is useful for troubleshooting and sampling.
Select Tool Use Select to include, exclude, and reorder the columns of data that pass through your workflow.
Sort Tool Use Sort to arrange the rows in a table in alphanumeric order based on the values of the specified data fields.
Tile Tool Use Tile to assign a value (tile) based on ranges in the data. The tool does this based on the user specifying 1 of 3 methods.
Unique Tool Use Unique to distinguish whether a row is unique or a duplicate by grouping on one or more specified columns, then sorting on those columns.

Workflow Join Tools

Append Columns Tool Use Append Columns to append every row from a source dataset to every row of a target dataset. This operation is also known as a cross join.
Find Replace Tool Use Find Replace to find a string in 1 column of a dataset and look up and replace it with another string. You can also use Find Replace to append columns to a row.
Join Tool Use Join to combine 2 inputs based on common columns between the 2 tables. You can also join 2 data streams based on row position.
Union Tool Use Union to combine 2 or more datasets on column names or positions.

Workflow Parse Tools

DateTime Tool Use DateTime to transform date-time data to and from a variety of formats, including both expression-friendly and human-readable formats.
RegEx Tool Use RegEx to use regular-expression syntax to parse, match, or replace data.
Text to Columns Tool Use Text To Columns to take the text in 1 column and split the string value into multiple separate columns or rows, based on a 1 or more delimiters.

Workflow Transform Tools

Arrange Tool Use Arrange to manually transpose and rearrange your columns for presentation purposes. Data is transformed so that each row is turned into multiple rows, and you can create new columns using column description data.
Count Rows Tool Use Count Rows to return a count of the number of rows passing through the tool. Use this tool when you want to report on the resulting row count of a process. It even returns a count of zero which a Summarize Tool does not do.
Cross Tab Tool Use Cross Tab to pivot the orientation of data in a table by moving vertical columns onto a horizontal axis and summarizing data where specified.
Summarize Tool Use Summarize to perform various actions (functions and calculations) on your data.
Transpose Tool Use Transpose to pivot the orientation of a data table.
Weighted Average Tool Use Weighted Average to calculate the weighted average of an incoming data column.

This page has no comments.