Skip to contents

Join a flat table with a lookup table

Source: R/flat_table_join.R
join_lookup_table.Rd

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 class 'flat_table'
join_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.

Value

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)