Alteryx Designer Advanced flashcards

32 cards. Read the term and the definition here. The deck at the top of this page is optional.

Join Multiple input limit

Join Multiple accepts between 2 and 256 inputs, requires at least one common field across inputs, and produces a Cartesian product for key combinations that appear in multiple inputs.

Union Auto by Name

Union configuration that matches fields across inputs purely by field name, so fields with different names are not combined even if they occupy the same position.

Unique tool output streams

The Unique tool splits data into a Unique stream (first occurrence of each key in input order) and a Duplicate stream (all later matches).

Multi-Row Formula Group By

Setting that resets the row reference at each group boundary, so Row-1 is null on the first row of each group rather than carrying the previous group's value.

Find Replace Append mode

Find Replace mode that adds the matched value as a new field instead of overwriting the original text; Replace mode overwrites the original field.

Fuzzy Match threshold

A value between 0 and 1 set per match field; higher thresholds require closer similarity, so raising it reduces the number of matched pairs.

RegEx Parse mode

RegEx mode that tokenizes a field into numbered or named capture groups, each exposed as a separate output field; unmatched groups return null.

RegEx Tokenize mode

RegEx mode that splits text into one output row per match of the pattern, rather than one row per input record.

Text to Columns Split to Rows

Text to Columns option that produces one row per token; the alternative, Split to Columns, produces new fields and requires a maximum column count.

Cross Tab aggregation

Tool that turns distinct values of a header field into columns and aggregates a data field by a group field; the group field defines row identity.

Transpose Name/Value output

Transpose collapses wide data fields into a Name/Value pair while key fields pass through, converting a wide layout into a tall one.

JSON Parse output fields

JSON Parse builds a schema from a JSON string and outputs JSON_Name and JSON_ValuePair fields, which are flattened with Select or Cross Tab.

DateTime tool null result

When the specified input or output format string does not match the data, the DateTime tool returns null rather than raising an error.

Spatial Match Contains vs Intersects

Contains requires the target geometry to lie entirely inside the source; Intersects is satisfied by any shared point, including a boundary touch.

Trade Area drive-time polygon

A polygon built from network drive-time data rather than a straight-line radius, so its shape follows roads and is not a perfect circle.

Spatial Process Dissolve

Spatial Process operation that merges adjacent polygons sharing a grouping key into a single geometry, removing internal boundaries.

Find Nearest distance field

Find Nearest returns the nearest feature within a maximum distance and adds a distance field to the output; results can be limited per target.

Project tool purpose

Converts spatial objects between coordinate systems using an EPSG code or .prj file; layers should share a projection before spatial operations.

Spatial Info area units

Area and length measurements on geographic latitude/longitude data are returned in degrees; reproject to a projected system before measuring.

Logistic Regression output

Predicts a binary target and returns probabilities plus a report with accuracy, precision, recall, and AUC; the classification cutoff is configurable.

Score tool requirement

Applies a model object from a predictive tool to new data; predictor fields must match the model's schema or the tool errors.

Forest Model variable importance

An ensemble of decision trees that does not produce a readable split report but reports variable importance and usually outperforms a single tree.

K-Centroids cluster count

K-means requires the analyst to choose k; Cluster Diagnostics helps select k using elbow or silhouette methods.

Oversample tool scope

Balances a skewed binary target by duplicating the minority class; apply to training data only, never to the holdout set.

Standard Macro file type

A .yxmc macro that replaces a tool in a workflow, accepting input through a Macro Input and returning results through a Macro Output.

Batch Macro Control Parameter

Tool that receives each iteration's value in a batch macro, letting the workflow run once per group or row of the incoming data.

Iterative Macro Condition tool

Iterative macros loop until a Condition tool is satisfied; the maximum iteration count is set in the Interface Designer properties.

Action tool Update Value

Interface Action that writes a question's value into a downstream tool's configuration, such as a Filter comparison or Formula expression.

Run Command tool

Developer tool that executes an external program or script; it requires an input stream and runs only when the workflow executes.

Performance Profiler

View menu feature that reports per-tool execution time when profiling is enabled, listing the slowest tools first to guide optimization.

Workflow Dependencies view

Options menu view listing all input and output paths and macros used by the workflow, used for packaging and sharing.

Output Data multi-file mode

Output option that writes one file per distinct value of a chosen field; the target directory must already exist or the tool errors.