Joins
Components to join two or more streams of data.
Cross Join
Description
This component performs a cross join.
Inputs
Main table [Table]Secondary table [Table]
Outputs
Result table [Table]
External links
Join
Description
This component performs an inner join.
Inputs
Main table [Table]Secondary table [Table]Column on main table [Column]Column on secondary table [Column]
Outputs
Result table [Table]
External links
Spatial Join
Description
This component performs a spatial join between two tables, based on a spatial predicate.
Inputs
Main table [Table]Secondary table [Table]Geo column on main table [Column]Geo column on secondary table [Column]Spatial predicate [Selection]
Outputs
Result table [Table]
ST Difference
Description
This component creates a new table containing the difference between the geographies of the input table and the combined boundary of the geographies in another table. That is, the part of the original geography that doesn't fall within the boundary of the ancillary table.
Geographies in the secondary table must be of type polygon.
Inputs
Source table [Table]Polygons table [Table]Geo column in source table [Column]Geo column in polygons table [Column]
Outputs
Result table [Table]
External links
ST Intersection
Description
This component creates a new table containing the intersection between the geographies of the input table and the geographies in another table.
Columns from both tables are copied to the output one, and a new one with the intersection is added.
Inputs
Source table [Table]Polygons table [Table]Geo column in source table [Column]Geo column in secondary table [Column]
Outputs
Result table [Table]
External links
Union All
Description
This component generates a new table that is the union of several input ones.
The input tables must have the same schema.
Inputs
Tables [Table]
Outputs
Result table [Table]
External links
Last updated
Was this helpful?