Join TST output with MSD output

Deprecated! See `tame_join`.

Usage

join_dp_msd(dp_filepath, msd_filepath, fy_as_str = TRUE, map_names = FALSE)

Arguments

dp_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

if (FALSE) {
#DP 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 (depricated)
  df_join <- join_dp_msd(tst_path, msd_path)
}