ALTERYX DESIGNER CORE EXAM
2025/2026 QUESTIONS AND ANSWERS
100% PASS.
Text Input Tool - ANS Manually add data which will be stored in the workflow.
Methods of Use:
(1) Copy & Paste
(2) Import a File
(3*) Enter values in cells
- Data lives WITHIN the workflow
- Values are static
- Can be shared by sharing the workflow
- Data is automatically categorized to smallest type and size
Data Types:
-Data types may need to match that of other inputs, especially when that data will be blended
with other data
-Be mindful of the characteristics of each data type and how it may impact your workflow later
on.
- Empty values are assigned null values
Input Data Tool - ANS Bring data into your workflow by selecting a file or connecting to a
database (optionally, using a query).
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
, - Data lives OUTSIDE the workflow
- Values update (are dynamic)
- Must export workflow to share files
- Data is configured based on the file type being imported
-Close all input files to avoid errors
- Previews the first 100 rows of data from the selected file
Output Data Tool - ANS Output the contents of a data stream to a file or database
- Has only 1 anchor for INPUT
- Take File/Table Name From Field
Browse Tool - ANS View data from a connected tool and view data profile information,
reporting snippets, maps, and behavior analysis information in the data.
Find Replace Tool - ANS Search for data in one field from one data stream and replace it with
a specified field from a different stream. Similar to an Excel VLOOKUP
Append Fields Tool - ANS 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 Tool - ANS Combine two data streams based on common fields (or record position). In
the joined output, each row will contain the data from both inputs.
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
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
2025/2026 QUESTIONS AND ANSWERS
100% PASS.
Text Input Tool - ANS Manually add data which will be stored in the workflow.
Methods of Use:
(1) Copy & Paste
(2) Import a File
(3*) Enter values in cells
- Data lives WITHIN the workflow
- Values are static
- Can be shared by sharing the workflow
- Data is automatically categorized to smallest type and size
Data Types:
-Data types may need to match that of other inputs, especially when that data will be blended
with other data
-Be mindful of the characteristics of each data type and how it may impact your workflow later
on.
- Empty values are assigned null values
Input Data Tool - ANS Bring data into your workflow by selecting a file or connecting to a
database (optionally, using a query).
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
, - Data lives OUTSIDE the workflow
- Values update (are dynamic)
- Must export workflow to share files
- Data is configured based on the file type being imported
-Close all input files to avoid errors
- Previews the first 100 rows of data from the selected file
Output Data Tool - ANS Output the contents of a data stream to a file or database
- Has only 1 anchor for INPUT
- Take File/Table Name From Field
Browse Tool - ANS View data from a connected tool and view data profile information,
reporting snippets, maps, and behavior analysis information in the data.
Find Replace Tool - ANS Search for data in one field from one data stream and replace it with
a specified field from a different stream. Similar to an Excel VLOOKUP
Append Fields Tool - ANS 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 Tool - ANS Combine two data streams based on common fields (or record position). In
the joined output, each row will contain the data from both inputs.
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
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
