left_join_codebook {MCOE}

When using the MCOE 'SQL' tables, it will merge codebook descriptions from CDE

Description

When using the MCOE 'SQL' tables, it will merge codebook descriptions from CDE

Usage

left_join_codebook(df, tablename, field)

Arguments

df

local dataframe you want to append labels to

tablename

which 'SQL' table is the data from

field

which field in the table do you want the labels for

Value

An 'tibble' of the same type as '.data'. The output has an one column names 'definition' which contains labels for the passed argument 'field'.

Examples

try(
sbac.filtered <- tbl(con, "CAASPP") |>
 head(100) |>
 collect() |>
 left_join_codebook("CAASPP", "Subgroup_ID")
)