dm (version 0.0.6.9000)

dm_join_to_tbl: Perform a join between two tables of a dm

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.

See Also

Other flattening functions: dm_flatten_to_tbl()

Examples

# NOT RUN {
dm_join_to_tbl(dm_nycflights13(), airports, flights)
# same result is achieved with:
dm_join_to_tbl(dm_nycflights13(), flights, airports)
# this gives an error, because the tables are not directly linked to each other:
try(dm_join_to_tbl(dm_nycflights13(), airlines, airports))
# }