rolap (version 2.5.1)

join_lookup_table: Join a flat table with a lookup table

Description

To join a flat table with a lookup table, the attributes of the first table that will be used in the operation are indicated. The lookup table must have the primary key previously defined.

Usage

join_lookup_table(ft, fk_attributes, lookup)
# S3 method for flat_table
join_lookup_table(ft, fk_attributes = NULL, lookup)

Value

A flat_table object.

Arguments

ft

A flat_table object.

fk_attributes

A vector of strings, attribute names.

lookup

A flat_table object.

Details

If no attributes are indicated, those that form the primary key of the lookup table are considered in the flat table.

See Also

flat_table

Other flat table join functions: check_lookup_table(), get_pk_attribute_names(), lookup_table()

Examples

lookup <- flat_table('iris', iris) |>
  lookup_table(
    measures = c("Sepal.Length", "Sepal.Width", "Petal.Length", "Petal.Width"),
    measure_agg = c('MAX', 'MIN', 'SUM', 'MEAN')
  )
ft <- flat_table('iris', iris) |>
  join_lookup_table(lookup = lookup)