Join gems
Join gems provide data enrichment and set operation capabilities for merging, combining, and comparing datasets. These gems enable you to connect related data from multiple sources, perform set operations, and create comprehensive datasets by combining information across different tables and data sources.
Gems
Access the following gems from the Join category in the gem drawer.
📄️ Join
Join two or more datasets
📄️ Union
Perform addition of rows from multiple tables
📄️ UnionByName
Combine datasets by aligning columns with the same name
📄️ Intersect
Return only the rows that are common across all input datasets
📄️ Except
Return rows from the first dataset that do not appear in any of the others