Join

The Join category includes tools that join two or more streams of data by appending data to wide or long schema.

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

Append Fields Tool: The Append Fields tool appends the fields of one small input (Source) to every record of another larger input (Target ). The result is a Cartesian Join where all records from both inputs are compared.

Find Replace Tool: The Find and Replace tool searches for data in one field from the input table and replaces it with a specified field from a different data table.

Fuzzy Match Tool: The Fuzzy Matching tool identifies non-identical duplicates of a database by specifying parameters to match on. Values need not be exact to find a match, they just need to fall within the user specified or prefabricated parameters set forth in the configuration properties.

Join Tool: The Join tool combines two inputs based on a commonality between the two tables. It functions like a SQL join but gives the option of creating three outputs resulting from the join.

Join Multiple Tool: The Join Multiple tool combines two or more inputs based on a commonality between the input tables. Only the joined records are outputted through the tool, resulting in a wide (columned) file.

Make Group Tool: The Make Group tool takes data relationships and assembles the data into groups based on those relationships.

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.