Join
This tool adds fields of a small input (Source) to every record of another larger input (Target).
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.
The Fuzzy Match Tool identifies non-identical duplicates of a dataset.
This tool combines two or more inputs based on a commonality between the input tables.
Use the Join tool to combine two inputs based on a common field(s) between the two tables.
This tool takes data relationships and assembles the data into groups based on those relationships.
The Union tool appends multiple data streams into one unified stream.