Tools of Alteryx Designer

Make Group

Assemble pairs of matches into groups based on their relationships. Generally used with the Fuzzy Match tool.

Directory

Returns all the files in a specified directory. Along with file names, other pertinent information about each file is returned, including file size, creation date, last modified, and much more.

Map Legend Splitter

Split the legend from the Report Map tool into its component parts for customization by other tools.

Apache Spark Code

allows the user to connect directly to an Apache Spark cluster instance and run commands directly from Alteryx.

Run Command

allows the user to run external command programs within Alteryx. This tool can be used as an Input, Output or as a pass through, intermediary tool.

Join In-DB

combines two in-database data streams based on common fields by performing an inner or outer join.

Join

combines two inputs based on a commonality between the two tables. It functions like a SQL join but gives the option of creating three outputs resulting from the join.

Union In-DB

combines two or more in-database data streams with similar structures based on field names or positions. In the output, each column will contain the data from each input.

Join Multiple

combines two or more inputs based on a commonality between the input tables. Only the joined records are outputted through the tool, resulting in a wide (columned) file.

Control Parameter

configures a control parameter input for each iteration of a batch macro.

Field Summary

analyzes data and creates a summary report containing descriptive statistics of data in selected columns. Use this tool to gain insight into data and receive recommendations for managing data.

Union

appends multiple data streams into one unified steam. The tool accepts multiple inputs based on either field name or record position, creating a stacked output table. The user then has complete control to how these fields stack or match up.

Append Fields

appends the fields of one input (Source) to every record of another larger input (Target). Each record of the target input will be duplicated for every record in the source input.

Overlay

arranges reporting snippets on top of one another for output using the Render tool.

Sort

arranges the records in a table in alphanumeric order, based on the values of the specified data fields.

Layout

arranges two or more reporting snippets to output as a report using the Render tool.

Spearman Correlation

assesses how well an arbitrary monotonic function could describe the relationship between two variables, without making any other assumptions about the particular nature of the relationship between the variables.

Data Stream In

brings data from a standard workflow into an in-database workflow.

Input Data

brings data in to your workflow by connecting to a file or database.

Detour

bypasses a process in a macro or analytic app.

Running Total

calculates a cumulative sum, per record, in a file.

Weighted Average

calculates the weighted average of an incoming data field. A weighted average is similar to a common average, but instead of all records contributing equally to the average, the concept of weight means some records contribute more than others.

Summarize

can conduct a host of summary processes, including: grouping, summing, count, spatial object processing, string concatenation, and much more.

Contingency Table

creates a contingency table based on selected fields, to list all combinations of the field values with frequency and percent columns.

Report Map

creates a map image from a workflow.

Record ID

creates a new column in the data and assigns a unique identifier, that increases sequentially, for each record in the data.

Macro Input In-DB

creates an in-database input connection on a macro and populates it with placeholder values.

Macro Output In-DB

creates an in-database output connection on a macro.

Macro Input

creates an input connection on a macro.

Macro Output

creates an output connection on a macro.

Table

creates basic data tables and pivot tables from input data.

Interactive Chart

creates interactive bar charts, line graphs, scatter plots, and pie charts for visualizing data in your workflow.

Generate Rows

creates new rows of data at the record level. It is useful to create a sequence of numbers, transactions, or dates.

Multi-Row Formula

creates or updates a column using an expression that can reference columns in a subsequent or prior row. It is useful for parsing complex data, and creating running totals, averages, percentages, and other mathematical calculations.

Formula

creates or updates columns using one or more expressions to perform a broad variety of calculations or operations.

Formula In-DB

creates or updates fields in an in-database data stream with an expression using the database's native language (e.g., SQL).

Error Message

displays an error message (and halts processing) for an app or macro based on criteria in an expression.

Map

displays an interactive map for the user to draw or select map objects in an app.

Browse

displays data from a connected tool as well as data profile information, maps, reporting snippets, and behavior analysis information in the data.

Field Info

displays in tabular form, the name of fields within a data stream as well as the field order, field type and field size.

API Output

displays the contents of a data stream in the Results window as a comma-delimited, quote-qualified string.

Violin Plot

displays the distribution of a single numeric variable, and conveys the density of the distribution.

Unique

distinguishes whether a data record is unique or a duplicate by grouping on one or more specified fields, then sorting on those fields. The first record in each group is sent to the Unique output stream while the remaining records are sent to the Duplicate output stream.

Connect In-DB

establishes a new or existing in-database connection in a workflow.

Multi-Field Binning

groups multiple numeric fields into tiles or bins, especially for use in predictive analysis.

Fuzzy Match

identifies non-identical duplicates of a database by specifying parameters to match on. Values need not be exact to find a match, they just need to fall within the user specified or prefabricated parameters set forth in the configuration properties.

Select

includes, excludes, and reorders the columns of data that pass through a workflow. You can also modify the type and size of data, rename a column, or add a description.

Python

is a code editor for users of Python.

R

is a code editor for users of R, an open-source code base used for statistical and predictive analysis.

Base64 Encoder

issues a base 64 encode string for a specified string field.

Insight

lets you create and arrange multiple charts and text elements into an interactive dashboard. Publish to a Gallery for others to gain a deeper understanding of the data.

Browse In-DB

lets you view your data at any point in an in-database workflow. Triggers a database query and can impact performance.

Sample In-DB

limits the in-database data stream to a number or percentage of records.

Scatterplot

makes enhanced scatterplots, with options to include boxplots in the margins, a linear regression line, a smooth curve via non-parametric regression, a smoothed conditional spread, outlier identification, and a regression line.

Multi-Field Formula

makes it easy to execute a single function on multiple fields.

Map Input

makes it possible to draw or select map objects (points, lines, and polygons) to be stored in the workflow.

Text Input

makes it possible to manually type text to create small data files for input, which can be useful for creating Lookup tables.

Arrange

manually transposes and rearranges your data fields for presentation purposes. Data is transformed so that each record is turned into multiple records and columns can be created by using field description data.

Pearson Correlation

measures the linear relationship between two or more random variables.

Frequency Table

produces a frequency analysis for selected fields. The output includes a summary of the selected fields with frequency counts and percentages for each value in a field.

Histogram

provides a histogram plot for a numeric field by showing the frequencies of records falling in a set of continuous value ranges. It also provides a smoothed empirical density plot. Frequencies are displayed when a density plot is not selected, and probabilities when this option is selected.

Importance Weights

provides methods for selecting a set of variables to use in a predictive model based on how strongly related each possible predictor is to the target variable.

Dynamic Rename

renames any or all fields within an input stream by employing the use of different methods. Additionally, dynamic or unknown fields can be renamed at runtime.

Dynamic Replace

replaces data values on a series of fields, based on a condition.

Message

reports messages about the process to the Results window.

JSON Parse

separates Java Script Object Notation text into a table schema for the purpose of downstream processing.

Throttle

slows down the speed of the downstream tool by limiting the number of records that are passed through.

Imputation

updates specific values in a numeric data field with another selected value. It is useful for replacing NULL values.

Email

uses a data stream to send emails for each record.

Heat Plot

uses a heat plot color map to show the joint distribution of two variables that are either continuous numeric variables or ordered categories.

Write Data In-DB

uses an in-database data stream to create or update a table directly in the database.

Test

verifies data or processes in a workflow. Since the Test tool accepts multiple inputs, with a single Test tool you can create multiple tests and test multiple sets of data and processes.

Numeric Up Down

Allow users to choose a number from a predefined range.

Text Box

Allow users to enter characters in a free form text box in an app.

Tree

Allow users to make one or more selections from an organized, hierarchal data structure in an app.

File Browse

Allow users to select a file to use as an input or output via a traditional file browse window.

Tile

Group data into sets based on value ranges in a field.

Explorer Box

displays a web page, file directory, or file on the canvas.

Map Legend Builder

Recombine the component parts of a map legend (created using the Map Legend Splitter) into a single legend table, after customization by other tools.

Comment

add annotation or images to the workflow canvas to capture notes or explain processes for later reference.

Report Footer

adds a footer to a report.

Report Header

adds a header to a report.

Image

adds graphics to reports.

Report Text

adds text to reports and documents.

Dynamic Select

allows fields to be selected either by field type or via a formula. Additionally dynamic or unknown fields will also be selected by field type or via formula at runtime.

Association Analysis

determines which fields in a database have a bivariate association with one another.

Date

displays a calendar in app, to allow users to select a date.

Check Box

displays a check box option in an app.

Folder Browse

displays a folder browse control in an app. This Interface tool is not supported for running apps in the Alteryx Analytics Gallery

List Box

displays a multi-selection check box list in an app.

Radio Button

displays a mutually exclusive option in an app.

Drop Down

displays a single selection list in an app.

Sample

extracts a specified portion of the records in the data stream.

Filter In-DB

filters in-database records with a basic filter or with a custom expression using the database's native language (e.g., SQL).

Distribution Analysis

fits one or more distributions to the input data and compares them based on a number of Goodness-of-Fit* statistics.

Data Cleansing

fixes common data quality issues using a variety of parameters.

Tool Container

organizes tools in a workflow into a box, which can be collapsed or disabled.

Basic Data Profile

outputs basic metadata such as data type, min, max, average, number of missing values, etc.

Dynamic Output In-DB

outputs information about the in-database workflow to a standard workflow for predictive in-database processing.

Transpose

pivots the orientation of data in a table by moving horizontal data onto a vertical axis.

Crosstab

pivots the orientation of the data table and transforms the data so vertical data fields can be viewed on a horizontal axis, summarizing data where specified.

Filter

queries records and splits the data into two outputs, True (where the data meets the specified criteria) and False (where it does not).

Blob Input

reads a Binary Large Object such as an image or media file, by browsing directly to a file or passing a list of files to read.

XDF Input

reads data from an XDF (.xdf) file, which is the format used by Microsoft R ScaleR functions to scale predictive analytics to millions of records for either using the .xdf file as input to a predictive analytics tool or reading the file into an Alteryx data stream for further data cleansing or blending.

Dynamic Input

reads from an input database at runtime and dynamically chooses what records to read in.

Auto Field

reads through an input file and sets the field type to the smallest possible size relative to the data contained within the column.

Download

retrieves data from a specified URL to be used in downstream processing or to be saved to a file.

Count Records

returns a count of how many records are going through the tool.

Date Time Now

returns a single record: the Date and Time at the workflow runtime, and convert the value into the string format of the user's choosing.

Random % Sample

returns an expected number of records resulting in a random sample of the incoming data stream.

Oversample Field

samples incoming data so that there is equal representation of data values so they can be used effectively in a predictive model.

Find Replace

search for data in one field from one data stream and replace it with a specified field from a different stream. Similar to an Excel VLOOKUP.

Select Records

selects specific records and/or ranges of records including discontinuous ranges. It is useful for troubleshooting and sampling

Select In-DB

selects, deselects, reorders, and renames fields in an in-database workflow.

Create Samples

splits the input records into two or three random samples. Specify the percentage of records that are in the estimation and validation samples, and if the total is less than 100%, the remaining records fall in the holdout sample.

Block Until Done

stops downstream processing until all records come through. This tool makes it possible to overwrite an input file.

Data Stream Out

streams data from an in-database workflow to a standard workflow, with an option to sort the records.

Summarize In-DB

summarizes in-database data by grouping, summing, counting, counting distinct fields, and more. The output contains only the result of the calculations.

Dynamic Input In-DB

takes In-DB Connection Name and Query fields from a standard data stream and inputs them into an in-database data stream.

Plot of Means

takes a numeric or binary categorical field (with the binary categorical field converted into a set of zero and one values) as a response field along with a categorical field and plots the mean of the response field for each of the categories (levels) of the categorical field.

Blob Convert

takes different data types and either convert them to a Binary Large Object (Blob) or takes a Blob and converts it to a different data type.

Condition

tests for the presence of user selections and returns either a true or false result

Render

transforms report snippets into reports in .pdf, .html, .xslx, .docx, .rtf and .pcxml formats.

Detour End

unifies the data processes from an upstream Detour tool into a single stream for further analysis in analytic apps and macro.

Action

update the configuration of a workflow with values provided by interface questions, when run as an app or macro.

XDF Output

writes an Alteryx data stream to an XDF (.xdf) file, which is the format used by Microsoft R ScaleR functions to scale predictive analytics to millions of records.

Blob Output

writes out each record into its own file.

Output Data

writes the results of a workflow to a file or database.