join_list_sql: Gets around limit of 1000 items in a list by iterating a...

In dgarmat/dgfunctionpack: Key Functions I Use Often

Description

Gets around limit of 1000 items in a list by iterating a query

Usage

join_list_sql(sortie_df, sql_left_join_to_in, sql_query_before_new_table,
  sql_query_after_new_table, conn)

Arguments

sortie_df	data frame of one column potentially > 1000 rows needing iteration in SQL because it's too long to turn into a list
sql_left_join_to_in	SQL code to SELECT the table to save as a left join starting point through the word IN just before the the (list)
sql_query_before_new_table	SQL code to select table to return from SELECT up to and not including the name of the temp table
sql_query_after_new_table	SQL code to select table to return after the name of the temp table through to the JOIN ON clause, etc.
conn	an open DBIConnection object, as returned by dbConnect()

Value

data_frame object

Examples

join_list_sql(mtcars, "wt", "mpg", "weight", "miles per gallon")

dgarmat/dgfunctionpack documentation built on May 17, 2020, 9:58 p.m.