1|Page
ALTERYX CORE EXAM NEWEST EXAM PREPARATION WITH
COMPLETE QUESTIONS AND CORRECT ANSWERS WITH
RATIONALES | ALREADY GRADED A+||BRAND NEW VERSION!!
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.
,2|Page
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|Page
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? - ANSWER-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? - ANSWER-
Select, Deselect, and Reorder Columns, Modify Data Type and Size, and
Rename a Column or Add a Description
, 4|Page
What happens if you generate too many records? - ANSWER-Warn/Error on
Too Many Records Being Generated: Since the Append Fields tool performs
a Cartesian join, you can unintentionally produce an excessive amount of
records. You can configure warnings or errors to be reported to ensure that
too many records are not produced.
-Allow All Appends: All records will be appended to all records with no error
or warning.
-Warn on appends of more than 16 Records: If more than 16 records are in
the Source file (S input) a warning is reported and the workflow continues
processing.
-Error on appends of more than 16 Records: If more than 16 records are in
the Source file (S input) an error is reported and the workflow stops
processing.
What are the two options to performing a Join? - ANSWER-1.) Join by
Record Position: Select this option when the two tables to be joined have the
same field structure, and the data will be joined by its position within the two
tables.
2.) Join by Specific Field: Select this option when the two tables have one or
more fields in common (like an ID) and the data will be joined together. You
ALTERYX CORE EXAM NEWEST EXAM PREPARATION WITH
COMPLETE QUESTIONS AND CORRECT ANSWERS WITH
RATIONALES | ALREADY GRADED A+||BRAND NEW VERSION!!
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.
,2|Page
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|Page
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? - ANSWER-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? - ANSWER-
Select, Deselect, and Reorder Columns, Modify Data Type and Size, and
Rename a Column or Add a Description
, 4|Page
What happens if you generate too many records? - ANSWER-Warn/Error on
Too Many Records Being Generated: Since the Append Fields tool performs
a Cartesian join, you can unintentionally produce an excessive amount of
records. You can configure warnings or errors to be reported to ensure that
too many records are not produced.
-Allow All Appends: All records will be appended to all records with no error
or warning.
-Warn on appends of more than 16 Records: If more than 16 records are in
the Source file (S input) a warning is reported and the workflow continues
processing.
-Error on appends of more than 16 Records: If more than 16 records are in
the Source file (S input) an error is reported and the workflow stops
processing.
What are the two options to performing a Join? - ANSWER-1.) Join by
Record Position: Select this option when the two tables to be joined have the
same field structure, and the data will be joined by its position within the two
tables.
2.) Join by Specific Field: Select this option when the two tables have one or
more fields in common (like an ID) and the data will be joined together. You
