Join within the EDCimport framework — edc_left

Perform a join with default by to the Subject ID and default suffix to the name of the y dataset. See [dplyr::mutate-joins] for the description of the join logic.

Usage

edc_left_join(
  x,
  y,
  by = NULL,
  suffix = NULL,
  cols = everything(),
  remove_dups = TRUE
)

Arguments

x, y: Data frames to join
by: The key to join on. Defaults to get_subjid_cols()
suffix: The disambiguation suffix. Defaults to the actual name of the y dataset.
cols: The columns to select in y before joining.
remove_dups: Whether to remove columns in y that already exist in x.

Value

a dataframe

Examples

db = edc_example()
#> Warning: Option "edc_lookup" has been overwritten.
load_database(db)
data1$common = data2$common = "Common"
x = enrol %>% 
  edc_left_join(data2) %>% 
  edc_right_join(data1)
  
#crfname get a suffix, common 
names(x)
#>  [1] "subjid"        "age"           "enrol_date"    "arm"          
#>  [5] "crfname"       "crfstat"       "date4"         "date5"        
#>  [9] "date6"         "crfname_data2" "common"        "date1"        
#> [13] "date2"         "date3"         "x"             "crfname_data1"