Join 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