Learn R Programming

TKCat (version 1.1.12)

join_mdb_tables: Join connected tables

Description

Join connected tables

Usage

join_mdb_tables(
  x,
  ...,
  type = c("left", "right", "inner", "full"),
  jtName = NA
)

Value

A metaMDB corresponding to x with the joined tables replaced by the joint. If less than 2 table names are provided, the function returns the original x MDB.

Arguments

x

an MDB object

...

at least 2 names of tables to join

type

the type of join among:

  • "left": includes all rows of the first provided table

  • "right": includes all rows of the last provided table

  • "inner": includes all rows in all provided tables

  • "full": includes all rows in at least one provide table

jtName

the name of the joint. IF NA (default), the name is then the name is the first provided table name.