fetch_new_NCtraining_data: Generate data frame containing new customer data for entire...
In dwalke44/customerClusters: Quickly Data Processing, Clustering, and Modeling

Description Usage Arguments Details Value Examples

View source: R/new_nccluster_data.R

fetch_new_NCtraining_data returns a data frame consisting of all new customers from the supplied year.

1	fetch_new_NCtraining_data(year, conn)

`year`	is the year of interest. Must be in the format YYYY. The function will convert to proper data type.
`conn`	is the name of a valid data base connection.

WARNING: THIS FUNCTION CAN TAKE >90 MINUTES TO COMPLETE QUERY.

This function will produce a data frame containing all unique customers of a given year, and >85 variables related to those customers. The query as written is restricted to new customers and does not generate data beyond information regarding their first purchase.

This function returns a single data frame.

## Not run: 
  con = dbConnect(odbc::odbc(), 'EDW_BA_PROD', uid = 'danwal1', pwd = 'XXXXXXXX')

## End(Not run)

 df = fetch_new_NCtraining_data(2018, conn = con)