Join
![Purple square with two white cogs, one of which contains a plus sign.](../../image/uuid-a859e43c-5d1c-398e-ebaf-5114987a3544.png)
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.](../../image/uuid-7f66807f-09e7-4675-2596-f7a24c10dd8f.png)
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.](../../image/uuid-0372a0ee-a852-d143-f393-39a8b075a3e5.png)
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.](../../image/uuid-c2315761-3118-a3ae-250e-95ac95d422c4.png)
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.](../../image/uuid-f9b13cd1-5718-a091-fdfa-c936c74743db.png)
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.](../../image/uuid-5a95c0e4-ee9d-2e50-6fb1-82f3226a255d.png)
This tool takes data relationships and assembles the data into groups based on those relationships.
![Purple box with white double helix.](../../image/uuid-ff4b293c-67ce-5319-56bf-c654313de524.png)
The Union tool appends multiple data streams into one unified stream.