1 | P a g e | © copyright 2024/2025 | Grade A+
Alteryx: Core Tool Review Questions
and Answers (100% Pass)
Text Input
✓ Manually add data which will be stored in the workflow
Input Data
✓ Bring data into you workflow by selecting a file or connecting to a
database (optionally, using a query)
Output Data
✓ Output the contents of a data stream to a file or database
Browse
✓ View data from a connected tool and view data profile information,
reporting snippets, maps, and behavior analysis information in the data
Find Replace
✓ Search for data in one field from one data stream and replace it with a
specified field from a different stream. Similar to Excel's VLOOKUP.
Master01 | September, 2024/2025 | Latest update
, 1 | P a g e | © copyright 2024/2025 | Grade A+
Append Fields
✓ Append the fields from a source input to every record of a target input.
Each record of the target input will be duplicated for every record in
the source input.
Join
✓ Combine two data streams based on common fields (or record
position). In the resulting output, each row will contain the data from
both inputs.
Union
✓ 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.
Unique
✓ Separate data into two streams, duplicate and unique records, based
on the fields of the user's choosing.
Select
Master01 | September, 2024/2025 | Latest update
Alteryx: Core Tool Review Questions
and Answers (100% Pass)
Text Input
✓ Manually add data which will be stored in the workflow
Input Data
✓ Bring data into you workflow by selecting a file or connecting to a
database (optionally, using a query)
Output Data
✓ Output the contents of a data stream to a file or database
Browse
✓ View data from a connected tool and view data profile information,
reporting snippets, maps, and behavior analysis information in the data
Find Replace
✓ Search for data in one field from one data stream and replace it with a
specified field from a different stream. Similar to Excel's VLOOKUP.
Master01 | September, 2024/2025 | Latest update
, 1 | P a g e | © copyright 2024/2025 | Grade A+
Append Fields
✓ Append the fields from a source input to every record of a target input.
Each record of the target input will be duplicated for every record in
the source input.
Join
✓ Combine two data streams based on common fields (or record
position). In the resulting output, each row will contain the data from
both inputs.
Union
✓ 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.
Unique
✓ Separate data into two streams, duplicate and unique records, based
on the fields of the user's choosing.
Select
Master01 | September, 2024/2025 | Latest update
