Skip to main content

Join

Purple square with two white cogs, one of which contains a plus sign.

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

Purple box with white magnifying glass and pencil.

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.

Purple box with two similar shapes and equals signs between.

The Fuzzy Match Tool identifies non-identical duplicates of a dataset.

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.

This tool combines two or more inputs based on a commonality between the input tables.

Purple box with multiple white circles with lines connecting them to a single white circle in the middle.

Use the Join tool to combine two inputs based on a common field(s) between the two tables.

Purple box with squares, diamonds and circles of varying colors sorted in rows by shape.

This tool takes data relationships and assembles the data into groups based on those relationships.

Purple box with white double helix.

The Union tool appends multiple data streams into one unified stream.

In this section: