ALTERYX CORE CERTIFICATION EXAM
QUESTIONS WITH CORRECT ANSWERS
What does the "Change Entire File Path" option do to the output data file? - Answer-
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? - Answer-Using the default sort,
numeric strings are sorted left to right, character by character
What does Dictionary Sort do to numeric string data? - Answer-Using the dictionary
sort, numeric strings are sorted from the smallest to largest number
What does the Auto Field Tool do? - Answer-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? - Answer-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? - Answer-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? - Answer-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? - Answer-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? - Answer-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? -
Answer-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? - Answer-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? - Answer-Build an Expression, Add an
Additional Expression, Reorder an Expression
What is the Multi-Row Formula tool used for? - Answer-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? - Answer-1.) Choose to
Update Existing Field or Create New Field. If creating a new field, enter a name, and
select the Type and Size.
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.
QUESTIONS WITH CORRECT ANSWERS
What does the "Change Entire File Path" option do to the output data file? - Answer-
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? - Answer-Using the default sort,
numeric strings are sorted left to right, character by character
What does Dictionary Sort do to numeric string data? - Answer-Using the dictionary
sort, numeric strings are sorted from the smallest to largest number
What does the Auto Field Tool do? - Answer-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? - Answer-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? - Answer-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? - Answer-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? - Answer-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? - Answer-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? -
Answer-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? - Answer-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? - Answer-Build an Expression, Add an
Additional Expression, Reorder an Expression
What is the Multi-Row Formula tool used for? - Answer-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? - Answer-1.) Choose to
Update Existing Field or Create New Field. If creating a new field, enter a name, and
select the Type and Size.
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.
