Join locations and bags from user data to the database

Join locations and bags from user data to the database

Usage

join_locations_and_bags(
  df.payload,
  con,
  location_root_col,
  level_I_col,
  level_II_col,
  dbs_bag_col
)

Arguments

df.payload

A dataframe with payload data.

con

A database connection object.

location_root_col

Column name in df.payload for the root location.

level_I_col

Column name in df.payload for level I location.

level_II_col

Column name in df.payload for level II location.

dbs_bag_col

Column name in df.payload for DBS bag name.

Value

A dataframe with joined location and bag details.