Learn R Programming

MCOE (version 0.6.0)

left_join_codebook: 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)

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`.

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

Examples

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

Run the code above in your browser using DataLab