Skip to content

Relational functions

mtbeek32 edited this page Mar 30, 2023 · 36 revisions

Relational functions are used to relate data items of different domain units like lookup or rjoin or create new domain units like subset or unique

  • id - index numbers
  • mapping - to map attributes between domain units
  • lookup - using a relation to find the relevant entries
  • rlookup - using a foreign key attribute to make a relation
  • rjoin - using a foreign key to find the relevant entries, combining lookup and rlookup
  • join_equal_values - find all combinations of A and B wherfe A.x_rel is equal to B.x_rel
  • collect_attr_by_org_rel - collects a set of attributes to a new domain unit, using an org_rel attribute (lookup)
  • collect_attr_by_cond - collects a set of attributes to a new domain unit, using a condition
  • unique - configures a new unit, based on the unique values
  • union - obsolete, only in use for backward compatibility
  • union_unit - configures a new unit, based on the union of other units
  • union_unit_uint8_16_32_64 - configures a new unit, based on the union of other units, with a uint8_16_32_64 values unit
  • union_data - configures a new attribute, based on the union of other data items
  • combine - configures a new unit, based on the Cartesian product of other units
  • combine_uint8_16_32_64 - configures a new unit, based on the Cartesian product of other units, with a uint8_16_32_64 values unit
  • combine_data - configures a new attribute, based on the Cartesian product of other data items
  • merge - merges the values of a data item, based on an option data item
  • overlay - an uint16 domain unit with the unique values of multiple grid attributes
  • overlay32 - an uint32 domain unit with the unique values of multiple grid attributes
Clone this wiki locally