Merge data.tables

Usage

dt_merge(
  left,
  right,
  on = NULL,
  left_on = NULL,
  right_on = NULL,
  how = "left",
  left_name = NULL,
  right_name = NULL,
  left_suffix = NULL,
  right_suffix = NULL,
  verbosity = 1L,
  ...
)

Arguments

left: data.table
right: data.table
on: Character: Name of column to join on.
left_on: Character: Name of column on left table.
right_on: Character: Name of column on right table.
how: Character: Type of join: "inner", "left", "right", "outer".
left_name: Character: Name of left table.
right_name: Character: Name of right table.
left_suffix: Character: If provided, add this suffix to all left column names, excluding on/left_on.
right_suffix: Character: If provided, add this suffix to all right column names, excluding on/right_on.
verbosity: Integer: Verbosity level.
...: Additional arguments to be passed to data.table::merge.

Value

Merged data.table.

Author

EDG

Examples

library(data.table)
xleft <- data.table(ID = 1:5, Alpha = letters[1:5])
xright <- data.table(ID = c(3, 4, 5, 6), Beta = LETTERS[3:6])
xlr_inner <- dt_merge(xleft, xright, on = "ID", how = "inner")
#> 2026-02-22 18:59:25 
#> ⨝ Merging xleft & xright on ID...
#>  [dt_merge]
#>             xleft 5 x 2
#>            xright 4 x 2
#>            Merged 3 x 3