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.
dm_join_to_tbl(dm, table_1, table_2, join = left_join)A dm object.
One of the tables involved in the join.
The second table of the join.
The type of join to be performed, see dplyr::join().
The resulting table of the join.
Other flattening functions:
dm_flatten_to_tbl()
# NOT RUN {
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)
)
# }
Run the code above in your browser using DataLab