ALTERYX CORE EXAM 2026/2027 WITH
ACTUAL CORRECT QUESTIONS AND
VERIFIED DETAILED RATIONALES
ANSWERS |CURRENTLY TESTING
QUESTIONS AND SOLUTIONS|ALREADY
GRADED A+|NEWEST|JUST
RELEASED!!|GUARANTEED PASS
What does the "Append Suffix to File/Table Name" option do to the output data file?
Appends the selected field name to the end of the name of the selected table.
What does the "Prepend Prefix to File/Table Name" option do to the output data file?
Prepends the selected field name to the beginning of the name of the selected table.
What does the "Change File/Table Name" option do to the output data file?
Changes the file name to the selected field name
What does the "Change Entire File Path" option do to the output data file?
Changes the file name to the name of the selected field. The name must be a complete file
path. This option can overwrite an existing file if a file exists in the full path directory
What does Default Sort do to numeric string data?
Using the default sort, numeric strings are sorted left to right, character by character
What does Dictionary Sort do to numeric string data?
Using the dictionary sort, numeric strings are sorted from the smallest to largest number
1|Page
,What does the Auto Field Tool do?
Use Auto Field to read through all of the records of an input and set the field type to the
smallest possible size relative to the data contained within the column.
The tool correctly assigns a numeric field to a string data type where any record starts with zero
and not a number.
What should you do after running the Duplicates tool?
Manual inspection. Manual inspection of the results is often necessary to ensure that rows
flagged as duplicates are actually duplicates. For example, you might have 2 customers that
share the same name but live at different addresses. If you think that your dataset might include
these types of outliers, you might want to select additional columns when you configure this
tool.
What is Sample tool used for?
Use Sample to limit the data stream to a specified number, percentage, or random set of rows.
In addition, the Sample tool applies the selected configuration to the columns selected to group
by
What is the option in the Sample tool to further sample the data?
Group by column: If a group or groups are specified, N rows are returned for each group.
If you select to Group by a column named City, specify N as 2, and select First N Rows, Alteryx
returns the first 2 rows for each City.
What other tools contain the Select tool functionality?
Append Fields tool, Find Nearest tool, Join tool, Join Multiple tool, Select In-DB tool, and Spatial
Match tool
What is the Select tool used for?
2|Page
,Use Select to include, exclude, and reorder the columns of data that pass through your
workflow. Excluding columns can limit the data passing through a workflow and improve
performance. You can also use the Select tool to modify the type and size of data, rename a
column, or add a description.
How do you change the supported length or measurement of data in the Select tool?
Select size and enter a number. Size varies by data types and can be edited for fixed decimal
numeric types and all string types
What are the ways you can use the Formula tool?
Apply conditional statements.
Convert numbers and strings.
Format dates.
Extract file paths.
Apply financial algorithms or mathematical calculations.
Find the minimum and maximum values.
Analyze spatial data.
Cleanse string data.
Perform validation tests on data.
What are the three functions of the Formula tool?
Build an Expression, Add an Additional Expression, Reorder an Expression
What is the Multi-Row Formula tool used for?
Utilize row data as part of the formula creation and is useful for parsing complex data, and
creating running totals, averages, percentages, and other mathematical calculations
What are the steps to configure the Multi-Row Formula tool?
1.) Choose to Update Existing Field or Create New Field. If creating a new field, enter a name,
and select the Type and Size.
3|Page
, 2.)Use Num Rows to set the row variables that display as in the expression editor. When set to
1, these variables display
Row - 1: The row before the active row.
Row + 0: This is the Active Row. The active row is where the result goes into.
Row + 1: The row after the active row.
3.)When the Active row is the first row, you need to specify the Values for Rows that don't exist.
Null: Null values are applied to nonexistent rows.
0 or Empty: The values are set to 0 or left empty (default).
Set to Values of Closest Valid Row: The values of the closest valid row are set to the nonexistent
rows.
4.)Group by (Optional): Either select fields individually or use the All or Clear buttons.
5.)Build the expression that will update the chosen field. Visit Expression Editor for details.
What is the Append Fields Tool and what is it used for?
Use Append Fields to append the fields of one small input (Source) to every record of another
larger input (Target). The result is a Cartesian join. In a Cartesian join, every row from one table
is joined to every row of another table. For example, if table A has 100 rows, and table B has
1,000 rows, the Cartesian join of these two tables results in 100,000 rows
What are some of the capabilities of the Append Fields Tool?
Select, Deselect, and Reorder Columns, Modify Data Type and Size, and Rename a Column or
Add a Description
What are the two sections of the Input Data Configuration window?
Connect a File or Database AND Options
What does entering "*" do with an input file?
4|Page
ACTUAL CORRECT QUESTIONS AND
VERIFIED DETAILED RATIONALES
ANSWERS |CURRENTLY TESTING
QUESTIONS AND SOLUTIONS|ALREADY
GRADED A+|NEWEST|JUST
RELEASED!!|GUARANTEED PASS
What does the "Append Suffix to File/Table Name" option do to the output data file?
Appends the selected field name to the end of the name of the selected table.
What does the "Prepend Prefix to File/Table Name" option do to the output data file?
Prepends the selected field name to the beginning of the name of the selected table.
What does the "Change File/Table Name" option do to the output data file?
Changes the file name to the selected field name
What does the "Change Entire File Path" option do to the output data file?
Changes the file name to the name of the selected field. The name must be a complete file
path. This option can overwrite an existing file if a file exists in the full path directory
What does Default Sort do to numeric string data?
Using the default sort, numeric strings are sorted left to right, character by character
What does Dictionary Sort do to numeric string data?
Using the dictionary sort, numeric strings are sorted from the smallest to largest number
1|Page
,What does the Auto Field Tool do?
Use Auto Field to read through all of the records of an input and set the field type to the
smallest possible size relative to the data contained within the column.
The tool correctly assigns a numeric field to a string data type where any record starts with zero
and not a number.
What should you do after running the Duplicates tool?
Manual inspection. Manual inspection of the results is often necessary to ensure that rows
flagged as duplicates are actually duplicates. For example, you might have 2 customers that
share the same name but live at different addresses. If you think that your dataset might include
these types of outliers, you might want to select additional columns when you configure this
tool.
What is Sample tool used for?
Use Sample to limit the data stream to a specified number, percentage, or random set of rows.
In addition, the Sample tool applies the selected configuration to the columns selected to group
by
What is the option in the Sample tool to further sample the data?
Group by column: If a group or groups are specified, N rows are returned for each group.
If you select to Group by a column named City, specify N as 2, and select First N Rows, Alteryx
returns the first 2 rows for each City.
What other tools contain the Select tool functionality?
Append Fields tool, Find Nearest tool, Join tool, Join Multiple tool, Select In-DB tool, and Spatial
Match tool
What is the Select tool used for?
2|Page
,Use Select to include, exclude, and reorder the columns of data that pass through your
workflow. Excluding columns can limit the data passing through a workflow and improve
performance. You can also use the Select tool to modify the type and size of data, rename a
column, or add a description.
How do you change the supported length or measurement of data in the Select tool?
Select size and enter a number. Size varies by data types and can be edited for fixed decimal
numeric types and all string types
What are the ways you can use the Formula tool?
Apply conditional statements.
Convert numbers and strings.
Format dates.
Extract file paths.
Apply financial algorithms or mathematical calculations.
Find the minimum and maximum values.
Analyze spatial data.
Cleanse string data.
Perform validation tests on data.
What are the three functions of the Formula tool?
Build an Expression, Add an Additional Expression, Reorder an Expression
What is the Multi-Row Formula tool used for?
Utilize row data as part of the formula creation and is useful for parsing complex data, and
creating running totals, averages, percentages, and other mathematical calculations
What are the steps to configure the Multi-Row Formula tool?
1.) Choose to Update Existing Field or Create New Field. If creating a new field, enter a name,
and select the Type and Size.
3|Page
, 2.)Use Num Rows to set the row variables that display as in the expression editor. When set to
1, these variables display
Row - 1: The row before the active row.
Row + 0: This is the Active Row. The active row is where the result goes into.
Row + 1: The row after the active row.
3.)When the Active row is the first row, you need to specify the Values for Rows that don't exist.
Null: Null values are applied to nonexistent rows.
0 or Empty: The values are set to 0 or left empty (default).
Set to Values of Closest Valid Row: The values of the closest valid row are set to the nonexistent
rows.
4.)Group by (Optional): Either select fields individually or use the All or Clear buttons.
5.)Build the expression that will update the chosen field. Visit Expression Editor for details.
What is the Append Fields Tool and what is it used for?
Use Append Fields to append the fields of one small input (Source) to every record of another
larger input (Target). The result is a Cartesian join. In a Cartesian join, every row from one table
is joined to every row of another table. For example, if table A has 100 rows, and table B has
1,000 rows, the Cartesian join of these two tables results in 100,000 rows
What are some of the capabilities of the Append Fields Tool?
Select, Deselect, and Reorder Columns, Modify Data Type and Size, and Rename a Column or
Add a Description
What are the two sections of the Input Data Configuration window?
Connect a File or Database AND Options
What does entering "*" do with an input file?
4|Page
