check_lookup_table: Check the result of joining a flat table with a lookup table

In rolap: Obtaining Star Databases from Flat Tables

Check the result of joining a flat table with a lookup table

Description

Before joining a flat table with a lookup table we can check the result to determine if we need to adapt the values of some instances or add new elements to the lookup table. This function returns the values of the foreign key of the flat table that do not correspond to the primary key of the lookup table.

Usage

check_lookup_table(ft, fk_attributes, lookup)

## S3 method for class 'flat_table'
check_lookup_table(ft, fk_attributes = NULL, lookup)

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.

Value

A tibble with attribute values.

See Also

flat_table

Other flat table join functions: get_pk_attribute_names(), join_lookup_table(), 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')
  )
values <- flat_table('iris', iris) |>
  check_lookup_table(lookup = lookup)

rolap documentation built on May 29, 2024, 10:38 a.m.