View source: R/flat_table_join.R
join_lookup_table | R Documentation |
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.
join_lookup_table(ft, fk_attributes, lookup)
## S3 method for class 'flat_table'
join_lookup_table(ft, fk_attributes = NULL, lookup)
ft |
A |
fk_attributes |
A vector of strings, attribute names. |
lookup |
A |
If no attributes are indicated, those that form the primary key of the lookup table are considered in the flat table.
A flat_table
object.
flat_table
Other flat table join functions:
check_lookup_table()
,
get_pk_attribute_names()
,
lookup_table()
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)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.