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.
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).
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.