queryLoad: Load and Save the queries from an excel workbook.

In finite2/dataCleaning: Query functions

Description

Load and Save the queries from an excel workbook.

Usage

queryLoad(file, queryRun = 1)

querySave(wb, q, file)

Arguments

file	fileName to load from or save to
queryRun	The number of the current
wb	The workbook object created by queryLoad
q	The query object with all queries checked and updated

Details

As a minimum the file to load should contain an "Instructions" and an "Initials" worksheet. The database has 12 columns: "id","identifier","queryRun","patid","CRF","repeatLine1","repeatLine2","firstQuery","STATScomments","comments","resolved","STATSresolved" these are checked by queryLoad to ensure there will be no errors later.

Functions

• querySave: Save the query object to excel

finite2/dataCleaning documentation built on May 20, 2019, 2:08 p.m.