addproreppar2tbl: Add product reporter and partner to a tbl object

In stix-global/eutradeflows: Download bilateral trade flow data from Eurostat Comext

Description

Add product reporter and partner to a tbl object

Usage

addproreppar2tbl(RMariaDBcon, maintbl)

addunit2tbl(RMariaDBcon, maintbl, tableunit = "vld_comext_unit")

Arguments

RMariaDBcon	database connection object created by RMySQL dbConnect
maintbl	tbl containing trade data, with productcode, reportercode and partnercode

Details

addunit2tbl joints all unit codes, then removes those which are out dated

Value

a tbl object left joined to the product, reporter and partner tables.

Examples

## Not run: 
con <- RMariaDB::dbConnect(RMariaDB::MariaDB(), dbname = "test")
monthly <- tbl(con, "raw_comext_monthly_201707")
monthly %>%
    filter(productcode == 44) %>%
    addproreppar2tbl(con, .) %>%
    collect()
RMariaDB::dbDisconnect(con)

## End(Not run)

stix-global/eutradeflows documentation built on Nov. 13, 2020, 9:23 p.m.