match_col_type: Match Column Type

In USAID-OHA-SI/tameDP: Import targets and PLHIV data from COP Target Setting Tool (formerly Data Pack)

Match Column Type

Description

This function utilizes the meta data stored in row 6 of each tab of the Data Pack to determine what column type is - "assumption", "calculation", "past", "result", "reference", "row_header", "target". The primary columns we want are meta data (row_header), targets, and past (prior year result/targets for reference).

Usage

match_col_type(filepath, tab, pattern = "(row_header|target|past)")

Arguments

filepath	file path to the Target Setting Tool importing, must be .xlsx
tab	which sheet to read in
pattern	type of column, "assumption", "calculation", "past", "result", "reference", "row_header", "target"; default = "(row_header|target|past)"

Value

Boolean list of matches

USAID-OHA-SI/tameDP documentation built on March 16, 2024, 6:26 a.m.