Alteryx: Core Tool Review
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.
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 - Select, deselect, reorder, and rename fields, change field type or size,
and assign a description
Select Records - Select specific records and/or ranges of records including
discontinuous ranges. Useful for troubleshooting and sampling.
Formula - Create or update columns using one or more expressions to perform a
broad variety of calculations and/or operations.
Sort - Sort records based on the values in one or more fields.
Sample - Limit the data stream to a number, percentage, or random set of
records.
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.
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 - Select, deselect, reorder, and rename fields, change field type or size,
and assign a description
Select Records - Select specific records and/or ranges of records including
discontinuous ranges. Useful for troubleshooting and sampling.
Formula - Create or update columns using one or more expressions to perform a
broad variety of calculations and/or operations.
Sort - Sort records based on the values in one or more fields.
Sample - Limit the data stream to a number, percentage, or random set of
records.
