ALTERYX DESIGNER TEST PAPER 2026
COMPLETE QUESTIONS AND CORRECT ANSWERS
⫸ Union Tool. Ans: Combine two or more data streams with similar
structures based on field names or position. In the output, each
column will contain the data from each input.
- Can accept multiple inputs
- First input connected determines output column names and data
types
- Re-name the connections to help identify data sources
- Re-organize the order in which data is combined
Joins Data by stacking vertically based on:
(1) Column Name
(2) Column Position
(3) Manually
⫸ Select Tool. Ans: Select, deselect, reorder, and rename fields,
change field type or size, and assign a description.
, ⫸ Select Records Tool. Ans: Select specific records and/or ranges of
records including discontinuous ranges. Useful for troubleshooting
and sampling.
⫸ Formula Tool. Ans: Create or update columns using one or more
expressions to perform a broad variety of calculations and/or
operations.
⫸ Sort Tool. Ans: Sort records based on the values in one or more
fields.
⫸ Sample Tool. Ans: Limit the data stream to a number, percentage,
or random set of records.
⫸ Filter Tool. Ans: Query records based on an expression to split
data into two streams. True (records that satisfy the expression) and
False (those that do not).
⫸ Data Cleansing Tool. Ans: Perform basic data cleansing operations
such as replacing null values, removing punctuation, and modifying
case.
⫸ Cross Tab Tool. Ans: Pivot the orientation of data in a table by
moving vertical data onto a horizontal axis and summarizing selected
data.
COMPLETE QUESTIONS AND CORRECT ANSWERS
⫸ Union Tool. Ans: Combine two or more data streams with similar
structures based on field names or position. In the output, each
column will contain the data from each input.
- Can accept multiple inputs
- First input connected determines output column names and data
types
- Re-name the connections to help identify data sources
- Re-organize the order in which data is combined
Joins Data by stacking vertically based on:
(1) Column Name
(2) Column Position
(3) Manually
⫸ Select Tool. Ans: Select, deselect, reorder, and rename fields,
change field type or size, and assign a description.
, ⫸ Select Records Tool. Ans: Select specific records and/or ranges of
records including discontinuous ranges. Useful for troubleshooting
and sampling.
⫸ Formula Tool. Ans: Create or update columns using one or more
expressions to perform a broad variety of calculations and/or
operations.
⫸ Sort Tool. Ans: Sort records based on the values in one or more
fields.
⫸ Sample Tool. Ans: Limit the data stream to a number, percentage,
or random set of records.
⫸ Filter Tool. Ans: Query records based on an expression to split
data into two streams. True (records that satisfy the expression) and
False (those that do not).
⫸ Data Cleansing Tool. Ans: Perform basic data cleansing operations
such as replacing null values, removing punctuation, and modifying
case.
⫸ Cross Tab Tool. Ans: Pivot the orientation of data in a table by
moving vertical data onto a horizontal axis and summarizing selected
data.
