Links

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