qc_findorphans: qc_findorphans

In Maritimes/Mar.datawrangling: A suite of tools for extracting, filtering and aggregating data from the Maritimes fisheries science databases

qc_findorphans

Description

This function creates zzz_orph_* tables with records that don't appear to be linked to the other tables (within Mar.datawrangling)

Usage

qc_findorphans(
  db = NULL,
  usepkg = "rodbc",
  data.dir = file.path(getwd(), "data"),
  debug = F
)

Arguments

db	default is NULL. This identifies the dataset you are working with.
usepkg	default is 'rodbc'. This indicates whether the connection to Oracle should use 'rodbc' or 'roracle' to connect. rodbc is slightly easier to setup, but roracle will extract data ~ 5x faster.
data.dir	The default is a 'data' folder under your working directory. This identifies where your existing RData files are.
debug	default = FALSE. This is passed to self_filter() which causes each filter to be printed out.

Author(s)

Mike McMahon, [e-mail]

Maritimes/Mar.datawrangling documentation built on Feb. 6, 2024, 3:25 a.m.