dm_join_to_tbl {dm} R Documentation

## Join two tables

### Description

A join of a desired type is performed between table_1 and table_2. The two tables need to be directly connected by a foreign key relation. Since this function is a wrapper around dm_flatten_to_tbl(), the LHS of the join will always be a "child table", i.e. a table referencing the other table.

### Usage

dm_join_to_tbl(dm, table_1, table_2, join = left_join)


### Arguments

 dm A dm object. table_1 One of the tables involved in the join. table_2 The second table of the join. join The type of join to be performed, see dplyr::join().

### Value

The resulting table of the join.

Other flattening functions: dm_flatten_to_tbl()

### Examples


dm_nycflights13() %>%
dm_join_to_tbl(airports, flights)

# same result is achieved with:
dm_nycflights13() %>%
dm_join_to_tbl(flights, airports)

# this gives an error, because the tables are not directly linked to each other:
try(
dm_nycflights13() %>%
dm_join_to_tbl(airlines, airports)
)



[Package dm version 0.2.8 Index]