Get Lower Table from Several Upper Table Fields

This function takes a list of subsets, a target lower level table name, and a list of tables. It returns a unique data frame containing the rows of the target lower level table that are associated with the given values of the upper table field in each subset. The function can also add the subset values to the result for reference.

Usage

getLowerTableSubsets(
  subsets,
  tblName,
  rdbesTables,
  combineStrata = TRUE,
  verbose = FALSE
)

Arguments

subsets

A named list of vectors. Each vector contains values for a specific upper table field.

tblName

A character string specifying the name of the target lower level table.

rdbesTables

A RDBESData object containing the tables.

combineStrata

A logical value indicating whether to include the strata information in the result. If TRUE, and if any strata has more than one value, those values are collapsed into a single string and appended to the result with a warning.

verbose

A logical value indicating whether to print informative text.

Value

A unique data frame containing the rows of the target lower level table that are associated with the given values of the upper table field in each subset. If combineStrata = TRUE, the result will also include a column for each subset with the corresponding collapsed values.

Details

The function recursively intersects the rows of the target lower level table that match the values from each subset in the upper tables. It then ensures that only unique rows are returned, based on the ID column of the target table.