Alteryx Core Flashcards
View data from a connected tool and view data profile information, reporting snippets, maps, and behavior analysis information in the data.
Browse Tool
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
Text Input Tool
Bring data into your workflow by selecting a file or connecting to a database (optionally, using a query).
- 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
Input Data Tool
Output the contents of a data stream to a file or database
- Has only 1 anchor for INPUT
- Take File/Table Name From Field
Output Data Tool
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
Find Replace Tool
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.
Append Fields Tool
Combine two data streams based on common fields (or record position). In the joined output, each row will contain the data from both inputs.
Join Tool
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
- First input connected determines output column names and data types
- Re-name the connections to help identify data sources
- Re-organize the order in which data is combined
Joins Data by stacking vertically based on:
(1) Column Name
Union Tool
Select, deselect, reorder, and rename fields, change field type or size, and assign a description.
Select Tool
Select specific records and/or ranges of records including discontinuous ranges. Useful for troubleshooting and sampling.
Select Records Tool
Create or update columns using one or more expressions to perform a broad variety of calculations and/or operations.
Formula Tool
Sort records based on the values in one or more fields.
Sort Tool
Query records based on an expression to split data into two streams. True (records that satisfy the expression) and False (those that do not).
Filter Tool
Perform basic data cleansing operations such as replacing null values, removing punctuation, and modifying case.
Data Cleansing Tool
Pivot the orientation of data in a table by moving vertical data onto a horizontal axis and summarizing selected data.
Cross Tab Tool
Pivot the orientation of the data in a table by moving horizontal data are on the vertical axis.
Transpose Tool
Summarize data by grouping, summing, counting, spatial processing, string concatenation, and much more. The output contains only the results of the calculation(s).
Summarize Tool
Count the records passing through the data stream. A count of zero is returned if no records pass through.
Count Records Tool
Transform date/time data to and from a variety of formats, including both expression-friendly and human readable formats.
DateTime Tool
Split the text from one field into separate rows of columns.
Text to Columns Tool
Organize tools into a single box which can be collapsed or disabled.
Tool Container
Add annotation or images to the workflow canvas to capture notes or explain processes for later reference.
Comment Tool
(1) Transparency
(2) Repeatability
(3) Safety
(4) Scalability
4 Benefits of Alteryx Designer
You have visibility of all the actions performed on the data set. The workflow shows what steps were taken and the order in which they were performed.
Transparency
