Alteryx Essentials cheat sheet

The canvas uses connection wires that are color-coded by data type: a solid arrow carries a data stream, a dotted line carries a field reference (name/type only), and a green arrow carries a spatial object.

Tool categories live on the Tool Palette: In/Out, Preparation, Join, Parse, Transform, Formula, Documentation, Developer, Spatial, and Reporting.

The Configuration window shows options for the currently selected tool; the Properties window shows workflow-level settings such as memory limits and canvas display.

Ctrl+R runs the entire workflow; running a single tool or a tool through a selected point uses the 'Run Workflow from Here' / 'Cache and Run Workflow' options on the tool's context menu.

The Results window shows per-tool output records and messages after a run; the Messages tab aggregates warnings and errors across the workflow.

An Annotation (tool comment) is display-only text and does not affect execution; the tool name itself is what appears in error messages.

The Workflow Configuration tab holds runtime settings including Temp Directory, Memory Limit, and whether to save the runtime settings with the workflow.

Disabled tools (grayed out) pass no records downstream; re-enable them before expecting data to flow through the branch.

The Overview Map and Interface Designer are separate windows accessed from View; the Interface Designer configures Analytic App and macro question layouts.

Input Data supports files, databases, and Alteryx databases; the file format is inferred from the extension, and options such as 'First Row Contains Field Names' control header parsing for delimited files.

Alteryx data types include String (fixed max length), V_String (variable length), WString/V_WString (wide/Unicode), Int16, Int32, Int64, Float, Double, Fixed Decimal, Bool, Date, DateTime, Time, and Blob.

Fixed Decimal with size 19.2 stores up to 19 total digits with 2 after the decimal; Float and Double are approximate binary types and can introduce rounding artifacts.

A String field's size is a maximum; values longer than the size are truncated on input or in a Select tool unless the size is increased.

The DateTime format string uses specifiers such as yyyy, MM, dd, HH, mm, ss; a DateTime value is stored as a single type, so date and time parts are extracted with DateTimeFormat or DateTimeParse.

Output Data appends or overwrites depending on the 'Output Options' setting; 'Overwrite file (Remove)' vs 'Append to Existing Sheet' matters for Excel outputs.

Excel output can create a new sheet, overwrite a sheet, or append; the sheet name can be taken from a field using the 'Take File/Table Name From Field' option.

The Auto Field tool inspects values and shrinks String/Int types to the smallest type that fits, which reduces memory but can truncate if later data is longer.

Boolean fields display as True/False (or 1/0) and are frequently produced by comparison expressions in the Formula tool.

The Data Cleansing tool can replace nulls with blanks or values, remove leading/trailing whitespace, change case, remove punctuation, and remove unwanted characters in one pass.

The Select tool renames, reorders, changes type and size, and deselects (drops) fields; 'Select All' plus deselect is the standard way to keep an explicit field list.

The Formula tool creates or updates a single field per expression; multiple expressions can be added in one tool, and each expression targets one output field.

The Multi-Row Formula tool references other rows via Row-1, Row+1, or Row-2 offsets; grouping fields restrict the row window to each group.

The Multi-Field Formula tool applies one expression to many selected fields at once; the '[CurrentField]' token refers to the field being processed.

The Sort tool orders records; the Record ID tool adds a sequential ID, and the Sample tool can take the first N, last N, every N, or a random N records.

The Imputation tool fills null values using a fixed value or a statistic (mean, median, mode) computed per field, optionally grouped.

The Unique tool splits records into unique and duplicate outputs based on selected key fields; the first occurrence is kept in the unique output by default.

The Filter tool routes records by a boolean expression: True goes to the T output, False to the F output; null results go to the False output.

The Join tool performs an inner join by default and outputs Left, Join (matched), and Right (unmatched) streams; unmatched records from both sides are preserved on the L and R outputs.

The Join Multiple tool combines three or more inputs on shared key fields and supports inner, left, right, and full outer join types.

The Union tool stacks records by field name, not position; 'Auto Config by Name' matches fields by name, while 'Auto Config by Position' aligns columns by order.

The Append Fields tool performs a Cartesian product (every record of the source against every record of the target) and is limited by the 'Allow All Appends' setting for large inputs.

The Find Replace tool looks up values in a lookup table and can replace the entire field or append the matched value; 'Append Field' preserves the original and adds the lookup result.

The Fuzzy Match tool scores string similarity (e.g., Jaro-Winkler, Levenshtein, Dice) and is used for approximate matching when exact keys differ.

The Make Group tool clusters records based on a similarity threshold and outputs a group ID per record cluster.

Join keys must be the same data type; a String key cannot join to a numeric key without an explicit conversion in a Select or Formula tool.

The Join tool's output field names collide when both inputs share a field name; the Join output keeps one copy and the L/R outputs keep their own copies.

The Text to Columns tool splits one field into multiple fields using a delimiter or a fixed width; the number of output columns is set explicitly.

The RegEx tool has modes: Match (parse), Replace, Tokenize, and Parse; Parse mode uses named groups like (?...) to create new fields.

The DateTime tool converts between string and DateTime types using an input format; DateTimeParse and DateTimeFormat in a Formula achieve the same result.

The Transpose tool pivots wide-to-long: selected fields become Name/Value pairs, one row per field per record.

The Crosstab tool pivots long-to-wide: a name field supplies column headers, a value field supplies cell values, and a group-by field identifies rows.

The Summarize tool aggregates with Group By, Sum, Count, Min, Max, Average, and Concatenate; Concatenate joins values with a chosen delimiter.

The Tile tool assigns records to equal-size tiles or by a numeric field's value ranges, producing a Tile_Num and optionally a Tile_SequenceNum.

The Running Total tool computes a cumulative sum, optionally grouped, and outputs a RunTot_ field alongside the original records.

The JSON Parse tool converts a JSON string field into a structured schema of fields; the output can be flattened with the Select and Transpose tools.

Spatial objects are stored as points, lines, or polygons; the Spatial Info tool reports area, length, centroid, and spatial object type.

The Spatial Match tool joins records based on spatial relationships such as 'Intersects', 'Contains', 'Touches', and 'Within a distance'.

The Trade Area tool builds a polygon around a point using a radius or drive-time; drive-time requires a configured spatial dataset or service.

The Create Points tool builds spatial points from latitude/longitude fields; the Create Spatial Object tool builds lines or polygons from coordinate fields.

The Spatial Process tool performs union, intersection, difference, and buffer operations on spatial objects.

The Distance tool computes the distance between two spatial objects and can output the nearest object per record.

The Find Nearest tool locates the closest records from a target stream within a maximum distance and returns a configurable number of matches.

Predictive tools include Linear Regression, Logistic Regression, Decision Tree, Forest Model, and the Predict tool, which scores new records with a saved model.

The Score tool reports model performance metrics such as accuracy, precision, recall, and RMSE depending on the model type.

A Standard Macro is a workflow saved as .yxmc and inserted as a tool; its inputs and outputs are defined by Macro Input and Macro Output tools.

A Batch Macro runs once per incoming record or group, with a Control Parameter feeding the iteration value into the macro.

An Iterative Macro loops until a condition is met; the Condition tool evaluates a boolean expression to stop the loop.

The Action tool in a macro updates a downstream tool's configuration (e.g., a filter expression or a file path) based on the incoming value.

The Interface tools (Text Box, Drop Down, List Box, Check Box, Numeric Up Down, File Browse) create questions in an Analytic App or macro.

The Formula tool supports conditional logic with IIF(condition, true, false) and IF...THEN...ELSE...ENDIF; nested IIF is evaluated left to right.

The Test tool evaluates a condition and routes records to True/False outputs, useful for validating data quality inside a workflow.

The Block Until Done tool sequences execution so that one branch (e.g., file creation) completes before another branch (e.g., reading that file) begins.

The Message tool can emit informational, warning, or error messages to the Results window and optionally stop the workflow on error.

The Performance Profile (Workflow > Run with Performance Profiling) reports per-tool execution time and record counts to locate bottlenecks.

The 'Cache and Run Workflow' option caches upstream tool results so downstream tools can be re-run without recomputing the whole branch.

The Select tool's explicit field list and the Auto Field tool reduce memory by trimming unused fields and shrinking oversized String types.

The Filter tool before a heavy Join or Spatial tool reduces record counts and speeds execution; pushing filters upstream is the standard optimization.

The Join tool is memory-bound: large many-to-many joins can exhaust memory, so pre-aggregating or filtering keys before the join is a common fix.

The Browse tool writes data to a temporary file and can slow large workflows; disable or remove Browse tools before production runs.

Common errors: 'Join keys must be the same type' (type mismatch), 'Field not found' (renamed or dropped field), and truncation warnings from String size limits.

The Workflow Configuration tab's Memory Limit and Temp Directory settings control where large sorts and joins spill; a Temp Directory with insufficient space causes failures.

The 'Run Only When Needed' / disabled-tool pattern lets you keep alternate branches in a workflow without executing them.