tame_join: Join TST output with MSD output

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

Join TST output with MSD output

Description

Join TST output with MSD output

Usage

tame_join(tst_filepath, msd_filepath, fy_as_str = TRUE, map_names = FALSE)

Arguments

tst_filepath	file path to the Target Setting Tool importing, must be .xlsx
msd_filepath	filepath to the latest PSNUxIM MSD for corresponding OU
fy_as_str	should FY be converted to a string (2025 > FY25) for Tableau? (default = TRUE)
map_names	import names from DATIM (OU, mechanism, partner) associated with mech_code when working with PSNUxIM (default = FALSE)

Value

dataframe that combines targets from the TST with corresponding historic results/targets from MSD

Examples

#TST file path
  tst_path <- "../Downloads/DataPack_Jupiter_20500101.xlsx"
# MSD filepath
  msd_path <- "../Data/MER_Structured_TRAINING_Datasets_PSNU_IM_FY59-61_20240215_v1_1.zip"

#run join function
  df_join <- tame_join(tst_path, msd_path)

#run join function without converting the fiscal year to a string (used in Tableau)
  df_join <- tame_join(tst_path, msd_path, fy_as_str = FALSE)

#run join function with PSNUxIM & map on mechanism info to TST dataframe
  df_join <- tame_join(tst_path, msd_path, map_names = TRUE)

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