get_bm_static: Pull a B&M static

Description Usage Arguments Value Examples

View source: R/query_functions.R

Description

This function returns a list of users for any given 12-month B&M static

Usage

1
get_bm_static(conn, static_end_date = "2017-12-31")

Arguments

conn

A database connection object

static_end_date

A SQL-formatted month-end date (see examples)

Value

A dataframe containing users and other details

Examples

1
2
3
4
5
vertica <- vertica_connect(driver.path)
# single static
df <- get_bm_static(vertica, static_end_date='2017-12-31') 
# for multiple statics
df <- get_bm_static(vertica, static_end_date=c("'2017-12-31', '2016-12-31'") 

cchoe/infoscout documentation built on May 20, 2019, 5:42 p.m.