Join

Link
Purple box with white magnifying glass and pencil.

Find Replace Tool

Use Find Replace to find a string in one column of a dataset and look up and replace it with the specified value from another dataset.
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

Use the Join tool to combine 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).