Join

Link
Purple box with white magnifying glass and pencil.

Find Replace Tool

This searches for data in an input table and replaces with specified text from a reference table.
Link
Purple box with white double helix.

Union Tool

The Union tool appends multiple data streams into one unified stream.
Link
Purple box with squares, diamonds and circles of varying colors sorted in rows by shape.

Make Group Tool

This tool takes data relationships and assembles the data into groups based on those relationships.
Link
Purple box with multiple white circles on the left with lines connecting them to a single white circle in the middle that is connected to another single circle on the right.

Join Multiple Tool

This tool combines two or more inputs based on a commonality between the input tables.
Link
Purple box with multiple white circles with lines connecting them to a single white circle in the middle.

Join Tool

The Join tool combines two inputs based on a common field(s) between the two tables.
Link
Purple box with two similar shapes and equals signs between.

Fuzzy Match Tool

The Fuzzy Match Tool identifies non-identical duplicates of a dataset.
Link
Purple square with two white cogs, one of which contains a plus sign.

Append Fields Tool

This tool adds fields of a small input (Source) to every record of another larger input (Target).