I85PREP
⌘ K
Alteryx Designer Advanced study materials
Alteryx Designer Advanced study resources

Alteryx Designer Advanced practice questions

One question at a time. Build your Alteryx Designer Advanced understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Data Preparation and Blending

In Alteryx Designer, which tool is used to combine two inputs that have different fields but the same record structure by stacking their rows?

  1. Append
  2. Join
  3. Fuzzy Match
  4. Union Correct answer.

Explanation

The Union tool stacks records from multiple inputs and reconciles differences in field names and types by position or by name. Join combines fields side-by-side based on matching keys.

Question 2Data Preparation and Blending

When configuring a Join tool, what does the J output anchor contain?

  1. Records that failed to parse
  2. Records from the left input with no match
  3. Records that matched on the join key Correct answer.
  4. Records from the right input with no match

Explanation

The Join tool has three outputs: J for matched records, L for unmatched left records, and R for unmatched right records. The J anchor holds only rows where the join keys matched.

Question 3Data Preparation and Blending

A user needs to add a running total of a numeric column within each customer group. Which tool accomplishes this most directly?

  1. Multi-Row Formula with group by Correct answer.
  2. Formula with a fixed constant
  3. Sort followed by Sample
  4. Summarize with Group By

Explanation

The Multi-Row Formula tool can reference rows above or below and supports grouping, making it suitable for running totals within groups. Summarize aggregates but does not produce per-row running values.

Question 4Data Preparation and Blending

Which tool should be used to split a single delimited string field into multiple separate fields?

  1. Data Cleansing
  2. Field Split
  3. Text to Columns Correct answer.
  4. RegEx

Explanation

The Text to Columns tool divides one field into multiple fields or rows using a delimiter. RegEx parses with patterns but is not the standard split-by-delimiter tool.

Question 5Data Preparation and Blending

A workflow must remove duplicate records based on the CustomerID field while keeping the first occurrence. Which tool configuration achieves this?

  1. Summarize tool with Count
  2. Unique tool with CustomerID selected as the key Correct answer.
  3. Sample tool with first N records
  4. Sort tool with CustomerID ascending

Explanation

The Unique tool outputs unique records on the U anchor and duplicates on the D anchor based on selected key fields. Selecting CustomerID as the key keeps the first occurrence and routes later duplicates to D.

Question 6Data Preparation and Blending

Which Alteryx tool is designed to identify and group records that are similar but not exactly equal, such as misspelled names?

  1. Join
  2. Fuzzy Match Correct answer.
  3. Find Replace
  4. Union

Explanation

The Fuzzy Match tool compares records using string-similarity algorithms and groups near-matches. Join requires exact key equality.

Question 7Data Preparation and Blending

In the Select tool, what does changing a field's type from String to Double do?

  1. Removes the field
  2. Converts the field's data type Correct answer.
  3. Renames the field
  4. Sorts the field

Explanation

The Select tool manages field metadata including name, type, size, and inclusion. Changing String to Double converts the field's data type so downstream tools treat it as numeric.

Question 8Data Preparation and Blending

A workflow needs to combine two tables so that every row of the left table pairs with every row of the right table. Which tool produces this result?

  1. Join Multiple
  2. Union
  3. Join
  4. Append Correct answer.

Explanation

The Append tool creates a Cartesian product, pairing every record from the source with every record from the target. Join matches on keys, and Union stacks rows.

Question 9Data Preparation and Blending

Which tool should be used to summarize sales by region and compute both the sum and the average of sales in one pass?

  1. Cross Tab
  2. Transpose
  3. Summarize Correct answer.
  4. Tile

Explanation

The Summarize tool groups records by selected fields and can compute multiple aggregations such as Sum and Average simultaneously. Cross Tab reshapes rows into columns.

Question 10Data Preparation and Blending

A dataset stores months as columns (Jan, Feb, Mar). To convert these columns into rows with a Month field and a Value field, which tool is used?

  1. Cross Tab
  2. Text to Columns
  3. Transpose Correct answer.
  4. Summarize

Explanation

The Transpose tool converts columns into rows, producing a name field and a value field. Cross Tab performs the reverse operation.

Question 11Data Preparation and Blending

Which tool is best suited to replace null values in a numeric field with a specified default value?

  1. Multi-Field Formula
  2. Record ID
  3. Imputation Correct answer.
  4. Data Cleansing

Explanation

The Imputation tool fills null values using a chosen method, including a fixed replacement value. Data Cleansing handles whitespace and nulls but not value imputation with a custom default.

Question 12Data Preparation and Blending

A user wants to apply the same calculation to many fields at once without writing a separate Formula tool for each. Which tool supports this?

  1. Multi-Field Formula Correct answer.
  2. Formula
  3. Dynamic Rename
  4. Multi-Row Formula

Explanation

The Multi-Field Formula tool applies one expression across multiple selected fields. The standard Formula tool operates on a single output field per expression.

Question 13Data Preparation and Blending

A user needs to standardize field names that arrive with inconsistent casing and spaces. Which tool addresses this?

  1. Select
  2. Dynamic Rename Correct answer.
  3. Data Cleansing
  4. Sort

Explanation

The Dynamic Rename tool can apply naming conventions to fields dynamically, including case and whitespace normalization. Select renames fields manually one at a time.

Question 14Data Preparation and Blending

When using the Join tool, what happens to records from the left input whose key does not match any record on the right?

  1. They cause the workflow to error
  2. They are written to the L output Correct answer.
  3. They are written to the J output
  4. They are dropped silently

Explanation

The Join tool routes unmatched left records to the L anchor, unmatched right records to the R anchor, and matched records to J. No records are dropped unless the user discards the L and R outputs.

Question 15Data Preparation and Blending

Which tool should be used to parse a date string with a custom format such as '20240115' into a proper Date type?

  1. Data Cleansing
  2. Formula with ToNumber
  3. Text to Columns
  4. DateTime tool Correct answer.

Explanation

The DateTime tool converts strings in specified formats into DateTime values and can also format DateTime values back into strings. Converting to a number alone does not yield a Date type.

Question 16Data Preparation and Blending

A workflow must sort records by Region ascending and then by Sales descending. How is this configured in the Sort tool?

  1. One Sort tool with two sort fields and per-field direction Correct answer.
  2. A Formula tool with a rank expression
  3. Two separate Sort tools chained together
  4. A Summarize tool with Group By

Explanation

The Sort tool accepts multiple sort fields and allows a separate ascending or descending direction for each. Ordering of the fields in the configuration defines sort precedence.

Question 17Data Preparation and Blending

Which tool assigns records to equal-sized groups based on a numeric field, commonly used for percentile analysis?

  1. Record ID
  2. Unique
  3. Tile Correct answer.
  4. Sample

Explanation

The Tile tool assigns each record to a tile based on a numeric field, supporting equal-record, equal-range, and custom interval methods. Sample selects records rather than bucketing them.

Question 18Data Preparation and Blending

A user wants to bring in only the columns needed from a large input and rename them in a single step. Which tool is most appropriate?

  1. Filter
  2. Union
  3. Select Correct answer.
  4. Formula

Explanation

The Select tool controls which fields are included and lets the user rename and retype them in one configuration. Filter separates rows by condition.

Question 19Data Preparation and Blending

Which tool should be used to join three separate inputs on a shared key in a single tool?

  1. Union
  2. Join
  3. Join Multiple Correct answer.
  4. Append

Explanation

The Join Multiple tool joins more than two inputs on common key fields in one step. The standard Join tool handles only two inputs.

Question 20Data Preparation and Blending

A user needs to replace values in one field using a lookup table of old and new values. Which tool is designed for this?

  1. Filter
  2. Sample
  3. Find Replace Correct answer.
  4. Transpose

Explanation

The Find Replace tool searches a field for values and replaces them with corresponding values from a lookup input. Filter splits rows by condition.

Question 21Data Preparation and Blending

In a Union tool configured to combine by name, what happens when one input has a field the other input lacks?

  1. The field is dropped from both inputs
  2. The missing field is filled with nulls for that input Correct answer.
  3. The workflow errors
  4. The field is renamed automatically

Explanation

When combining by name, fields present in only one input are retained and populated with nulls for records from the input that lacks them. This preserves all fields across inputs.

Question 22Data Preparation and Blending

A workflow uses a Join tool on a key where the right input contains duplicate key values. What is the effect on the J output?

  1. Each left record is duplicated for every matching right record Correct answer.
  2. Duplicate right keys are removed before joining
  3. Only the first right match is joined
  4. The join fails

Explanation

A standard Join produces one output row for each left-right key match combination, so duplicate keys on the right multiply matched rows. Deduplicating the right input first is a common remedy.

Question 23Data Preparation and Blending

A user wants to pivot data so that distinct values in a Category field become new columns containing aggregated amounts. Which tool performs this?

  1. Multi-Row Formula
  2. Cross Tab Correct answer.
  3. Transpose
  4. Summarize

Explanation

The Cross Tab tool pivots rows into columns, using a chosen field for new column headers and an aggregation method for the values. Transpose performs the inverse reshaping.

Question 24Data Preparation and Blending

A dataset has nulls in a numeric field, and a downstream calculation fails. Which approach most reliably prevents the failure while preserving record count?

  1. Impute nulls with a default value Correct answer.
  2. Filter out null records
  3. Change the field to String
  4. Sort the field ascending

Explanation

Imputing nulls replaces them with a usable value so calculations can proceed without dropping records. Filtering removes records and changes the row count.

Question 25Data Preparation and Blending

A user needs to detect records whose values differ between two inputs that share an ID, outputting only the changed rows. Which combination best accomplishes this?

  1. Join on ID, then Filter on field inequality Correct answer.
  2. Transpose, then Cross Tab
  3. Union by position, then Unique
  4. Append, then Summarize

Explanation

Joining the two inputs on ID aligns corresponding records, and a Filter on the inequality of the compared fields isolates changed rows. Union and Append do not align records by key for comparison.

Question 26Data Preparation and Blending

In the Select tool, which action changes a field's name while leaving its data values and type untouched?

  1. Rename the field in the Rename column Correct answer.
  2. Set the field's Size to a larger value
  3. Change the field's Type to V_String
  4. Check the field in the Select column

Explanation

The Select tool exposes a Rename column where a new name can be typed; the underlying data and type are preserved. Type and Size settings alter how the data is stored or interpreted, not its label. The Select checkbox only controls whether the field passes downstream.

Question 27Data Preparation and Blending

A user needs to split a single delimited string field into multiple separate fields. Which tool is purpose-built for this?

  1. Text to Columns Correct answer.
  2. Data Cleansing
  3. Formula
  4. RegEx

Explanation

The Text to Columns tool splits one string field into several fields using a specified delimiter. Formula and RegEx can manipulate strings but do not natively produce multiple output fields from one split. Data Cleansing handles whitespace and case cleanup, not field splitting.

Question 28Data Preparation and Blending

Which tool is designed to compare two inputs and output the records that exist only in the left input, only in the right input, and in both?

  1. Join Correct answer.
  2. Append Fields
  3. Fuzzy Match
  4. Union

Explanation

The Join tool produces Left, Join, and Right outputs, separating unmatched left records, matched records, and unmatched right records. Append Fields performs a cross join, and Union stacks records rather than comparing keys. Fuzzy Match groups similar strings rather than matching exact keys.

Question 29Data Preparation and Blending

Which tool should be used to remove leading and trailing whitespace and normalize casing across several text fields at once?

  1. Sample
  2. Data Cleansing Correct answer.
  3. Sort
  4. Unique

Explanation

The Data Cleansing tool can trim whitespace, remove unwanted characters, and standardize case for selected fields in one pass. Sort and Sample reorder or subset records, and Unique removes duplicate rows. None of those alter text formatting.

Question 30Data Preparation and Blending

A user wants to create a new numeric field equal to Price multiplied by Quantity for every record. Which tool configuration achieves this?

  1. Formula tool with a new field named Total and expression [Price] * [Quantity] Correct answer.
  2. Summarize tool with Group By on Price
  3. Sort tool with Price ascending
  4. Select tool with Size increased on Price

Explanation

The Formula tool creates a new field and evaluates an expression per record, so [Price] * [Quantity] yields a row-level product. Select, Summarize, and Sort do not perform per-record arithmetic to create new fields. Summarize aggregates rather than computing row-level results.

Question 31Data Preparation and Blending

A user needs to keep only records where Status equals 'Active' before joining to another dataset. Which tool performs this filtering?

  1. Join
  2. Unique
  3. Filter Correct answer.
  4. Sample

Explanation

The Filter tool splits records into True and False outputs based on a condition such as [Status] = 'Active'. Sample selects records by count or percentage, Unique deduplicates by key, and Join combines datasets on a key. Only Filter evaluates a row-level condition to route records.

Question 32Data Preparation and Blending

A user has a field containing values like ' New York ' and 'new york ' and wants them to group together in a Summarize. Which approach most directly standardizes the values first?

  1. Use a Sample tool to keep the first record
  2. Use Sort to order the field alphabetically
  3. Use a Select tool to increase the field size
  4. Use Data Cleansing to trim whitespace and standardize case on the field Correct answer.

Explanation

Trimming whitespace and normalizing case makes the values identical so Summarize groups them together. Sorting changes order but not the stored strings, and increasing field size does not alter content. Sampling records does not standardize values.

Question 33Data Preparation and Blending

In a Join tool, the left input has 10 records and the right input has 5 records, and all keys match one-to-one. How many records appear in the Join output?

  1. 5 Correct answer.
  2. 10
  3. 15
  4. 50

Explanation

With a one-to-one key match, the Join output contains one record per matched key pair, so the count equals the number of matching keys, which is 5 here. The left-only and right-only outputs receive unmatched records, of which there are none. Outputs are not summed or multiplied in a one-to-one match.

Question 34Data Preparation and Blending

A user wants to append a running total of Amount ordered by Date to each record. Which tool provides a running total field?

  1. Summarize tool
  2. Multi-Row Formula tool
  3. Running Total tool Correct answer.
  4. Tile tool

Explanation

The Running Total tool adds a cumulative sum field based on the order of records entering the tool. Multi-Row Formula can reference prior rows but requires manual expression setup to accumulate. Summarize aggregates groups, and Tile assigns group numbers.

Question 35Data Preparation and Blending

A user needs to generate all combinations of two small tables so each left row pairs with each right row. Which tool performs this?

  1. Join
  2. Find Replace
  3. Union
  4. Append Fields Correct answer.

Explanation

The Append Fields tool performs a cross join, pairing every record of one input with every record of the other. Join requires matching keys, Union stacks records, and Find Replace substitutes values from a lookup. Only Append Fields creates the full Cartesian pairing.

Question 36Data Preparation and Blending

A user wants to convert a wide table where each product is a column into a long table with Product and Sales fields. Which tool accomplishes this?

  1. Transpose Correct answer.
  2. Summarize
  3. Cross Tab
  4. Unique

Explanation

The Transpose tool turns selected columns into rows, producing a key field and a value field, which converts wide data to long form. Cross Tab performs the reverse pivot from rows to columns. Summarize and Unique do not reshape the table.

Question 37Data Preparation and Blending

A user needs to replace values in a field using a separate lookup table that maps old codes to new descriptions. Which tool is designed for this?

  1. Formula
  2. Join
  3. Text to Columns
  4. Find Replace Correct answer.

Explanation

The Find Replace tool searches a field for values from a lookup input and substitutes the corresponding replacement values. Formula applies expressions but does not reference a separate lookup table by default. Join combines datasets but does not substitute values within a field.

Question 38Data Preparation and Blending

A user wants to assign a sequential record ID to each row after sorting, so the IDs reflect the sorted order. Which configuration achieves this?

  1. Sort the records first, then use a Record ID tool after the Sort Correct answer.
  2. Use a Record ID tool before the Sort
  3. Use a Multi-Row Formula with a constant value
  4. Use a Select tool to reorder the fields

Explanation

The Record ID tool numbers records in the order they enter it, so placing it after the Sort assigns IDs in sorted order. Placing it before the Sort numbers records in their original order, and the subsequent sort would detach IDs from sorted position. Multi-Row Formula with a constant does not create sequential IDs.

Question 39Data Preparation and Blending

Two inputs share an ID field, but one stores ID as an integer and the other as a string. A Join returns no matched records. What is the most likely cause?

  1. The Sort tool was not applied before the Join
  2. The fields were not renamed to identical names
  3. The Join tool cannot accept more than one input
  4. The ID fields have different data types, so values do not match Correct answer.

Explanation

Join matches on both value and compatible data type; an integer ID and a string ID representing the same digits will not match. Converting one field to match the other's type resolves the issue. Join accepts two inputs by design, sorting is not required for matching, and field names need not be identical if the keys are selected.

Question 40Data Preparation and Blending

A workflow needs to detect records whose Amount differs between an old and a new extract sharing an ID, and output only the changed rows. Which approach most directly isolates the changes?

  1. Append Fields and compare every row to every row
  2. Union the two inputs and deduplicate with Unique
  3. Join on ID, then filter where the Amount fields from each side are not equal Correct answer.
  4. Transpose both inputs and sort by Amount

Explanation

Joining on ID aligns old and new records, and a Filter on inequality between the two Amount fields keeps only rows whose values changed. Union with Unique removes exact duplicates but does not compare field values across sources. Append Fields creates a cross join that does not align records by ID.

Question 41Advanced Parsing and Transformation

In the RegEx tool, what does the 'Parse' output method do when the regular expression contains marked groups?

  1. It appends the full match to the field as a single concatenated string
  2. It creates one new column per marked group, populated with the matched substring Correct answer.
  3. It replaces the matched text inside the original field with the group value
  4. It splits the field into rows, one row per matched group occurrence

Explanation

Parse mode emits a separate output column for each marked (capturing) group in the expression, holding the text that group captured. It does not modify the input field or change record granularity.

Question 42Advanced Parsing and Transformation

Which RegEx output method should be used to turn a single delimited field into multiple rows, one per match?

  1. Tokenize Correct answer.
  2. Match
  3. Replace
  4. Parse

Explanation

Tokenize splits the value into multiple output rows, one for each match of the pattern. Parse creates columns rather than rows, and Match only flags whether a pattern was found.

Question 43Advanced Parsing and Transformation

A Text to Columns tool is configured with a backslash (\) as the delimiter. What must the user do for the tool to split on a literal backslash?

  1. Choose the 'Special Character' delimiter mode instead
  2. Wrap the delimiter in square brackets like [\]
  3. Nothing; a lone backslash is always treated literally
  4. Enter \\ in the delimiter field to escape it Correct answer.

Explanation

Text to Columns treats the delimiter as a regular expression, and a backslash is an escape character in regex, so it must be escaped as a double backslash to match a literal backslash. Simply entering a single backslash produces an invalid or unintended pattern.

Question 44Advanced Parsing and Transformation

Which parsing tool is designed to extract values from semi-structured text such as log lines by matching a defined template?

  1. Text to Columns
  2. RegEx Correct answer.
  3. Formula
  4. DateTime

Explanation

The RegEx tool matches patterns against free-form text and can capture the desired substrings, making it the standard choice for semi-structured logs. Text to Columns only splits on delimiters and cannot express a template.

Question 45Advanced Parsing and Transformation

In a RegEx expression, what does the pattern \d{3}-\d{2}-\d{4} match?

  1. A number with exactly nine digits and no separators
  2. Any three characters followed by any four characters
  3. Three digits, a dash, two digits, a dash, four digits Correct answer.
  4. Three letters, a dash, two letters, a dash, four letters

Explanation

\d matches a single digit and {n} is a quantifier requiring exactly n repetitions, so the pattern matches a 3-2-4 digit group separated by literal dashes. The dashes are literal characters in the pattern.

Question 46Advanced Parsing and Transformation

Which JSON Parse tool behavior occurs when the selected field contains a JSON array of objects?

  1. Only the first object of the array is parsed and the rest are dropped
  2. Each object becomes a separate output row with its keys as fields Correct answer.
  3. The tool fails because only flat JSON objects are supported
  4. The array is written to a single string field unchanged

Explanation

JSON Parse expands a JSON array by producing one output record per element, promoting the object keys to fields. This is how nested array data is flattened into tabular rows.

Question 47Advanced Parsing and Transformation

A field holds the JSON string {"id":101,"tags":["a","b"]}. After JSON Parse, how are the nested array values typically represented?

  1. As two additional rows, one per tag
  2. As a null field because arrays cannot be parsed
  3. As a single field containing the serialized array text Correct answer.
  4. As two separate fields named tags_1 and tags_2

Explanation

JSON Parse promotes top-level object keys to fields; a nested array value is retained as a serialized string in its field so it can be further processed with a second parse step. It does not automatically fan out nested arrays into rows.

Question 48Advanced Parsing and Transformation

Which tool splits a single text field into multiple fields based on a specified delimiter or field width?

  1. Text Input
  2. Sample
  3. Record ID
  4. Text to Columns Correct answer.

Explanation

Text to Columns divides one field into several fields using a delimiter or fixed widths. The other tools create records or inputs but do not split fields.

Question 49Advanced Parsing and Transformation

A user configures Text to Columns with a comma delimiter but some rows contain commas inside quoted values. What is the most reliable approach to preserve those values intact?

  1. Set the delimiter to a space to avoid commas entirely
  2. Increase the number of output columns so extra commas fit
  3. Run the tool twice with the same comma delimiter
  4. Use the CSV parser settings that honor quoted fields instead of a plain regex split Correct answer.

Explanation

CSV-aware parsing respects quoting rules so delimiters inside quotes are not treated as separators. A plain delimiter split cannot distinguish quoted commas from field separators.

Question 50Advanced Parsing and Transformation

Which XML Parse tool mode returns the element names and their values as separate fields for each record?

  1. It returns a binary blob of the XML document
  2. It returns one row per element with name and value fields Correct answer.
  3. It returns only attributes and ignores element text
  4. It returns a single concatenated string of all element values

Explanation

XML Parse can output one row per matched element, with fields carrying the element name and its value, which supports downstream filtering and reshaping. It does not collapse the document into one string by default.