Join
Back to: Index of transforms
Transforms in this section perform some sort of a join operation. Learn more about how to search for and add a transformation.
Join to transform tables
Performs a left, inner or right join of two transform tables based on one or more matching conditions. Select which columns from the source and joining tables you wish to retain. Optionally, add a prefix to the joined columns to avoid name collisions with existing columns, or to annotate the joined columns.
Join to linked objects
Perform a left join with linked objects using a link relation.
Cross join transform tables
Joins each row in the left table with all rows in the right table.
Union
Union with another transform table.