Favorites

The Favorites category includes the most common tools used in workflow creation. You can add a tool to the Favorites category by clicking the gray star in the top right of the tool icon on the Tool Palette. A yellow star indicates a tool is in the Favorites category.

Visit the Alteryx Community Tool Mastery series to learn even more about these and other tools.

Browse Tool: The Browse tool displays data from a connected tool as well as data profile information, maps, reporting snippets, and behavior analysis information in the data.

Input Data Tool: The Input Data tool brings data in to your workflow by connecting to a file or database.

Output Data Tool: The Output Data tool writes the results of a workflow to a file or database.

Text Input Tool: The Text Input tool makes it possible to manually type text to create small data files for input, which can be useful for creating Lookup tables.

Data Cleansing Tool: The Data Cleansing tool fixes common data quality issues using a variety of parameters.

Filter Tool: The Filter tool queries records and splits the data into two outputs, True (where the data meets the specified criteria) and False (where it does not).

Formula Tool: The Formula tool creates or updates columns using one or more expressions to perform a broad variety of calculations or operations.

Sample Tool: The Sample tool extracts a specified portion of the records in the data stream.

Select Tool: The Select tool includes, excludes, and reorders the columns of data that pass through a workflow. With the Select tool you can also modify the type and size of data, rename a column, or add a description.

Sort Tool: The Sort tool arranges the records in a table in alphanumeric order, based on the values of the specified data fields.

Join Tool: The Join tool combines two inputs based on a commonality between the two tables. Its function is like a SQL join but gives the option of creating 3 outputs resulting from the join.

Union Tool: The Union tool appends multiple data streams into one unified steam. The tool accepts multiple inputs based on either field name or record position, creating a stacked output table. The user then has complete control to how these fields stack or match up.

Text To Columns Tool: The Text To Columns tool takes the text in one column and splits the string value into separate, multiple fields based on a single or multiple delimiter(s).

Summarize Tool: The Summarize tool can conduct a host of Summary Processes, including: grouping, summing, count, spatial object processing, string concatenation, and much more.

Comment Tool: The Comment tool adds annotation to the project workspace. This is useful to jot down notes, explain processes to share or reference later.