the FY21 wide templates create one more column than the FY22 wide templates when split. This is due to the FY21 wide templates splitting the disagg group and categories in those group into two separate fields. the FY22 templates keep them together. To address this issues in processing I suggest that for FY21 wide templates. the headers are updated using search and replace before being split so that the columns align with FY22 wide templates.
Below is a table of the text that should be updated in the FY22 and FY21 wide templates before splitting into columns (using period (.) as the delimiter). Before applying search and replace the headers should
the FY21 wide templates create one more column than the FY22 wide templates when split. This is due to the FY21 wide templates splitting the disagg group and categories in those group into two separate fields. the FY22 templates keep them together. To address this issues in processing I suggest that for FY21 wide templates. the headers are updated using search and replace before being split so that the columns align with FY22 wide templates.
Below is a table of the text that should be updated in the FY22 and FY21 wide templates before splitting into columns (using period (.) as the delimiter). Before applying search and replace the headers should
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">
FY22 search for | FY22 replace with -- | -- ".n1" | ".n" "(in prep, the site type column ends in n 1, can be used to differentiate) ".f." | ".female." ".m." | ".male." FY21 search for | FY21 replace with -- | -- ":." | ":" "type." | "type:" "....." | "...." "male...." | "male..." "method.fp" | "method:fp" "method.device" | "method:device" "method:." | "method:" "service.fp" | "service:fp" "service:." | "service:" "eid_status:." | "eid_status." ".numerator" | "n" ".numerator." | "n" ".denominator" | "d" ".denominator." | "d" ".female." | ".f." ".male." | ".m." ".<" | ".u" ".45+." | ".o45." ".50+." | ".o50." "2mo." | "2m." "1-" | "1_" "5-" | "5_" "0-" | "0_" "8-" | "8_" ".unknown." | ".unknownage." ".non_kp_gp." | ".nonkpgp." ".non_kp_sero." | ".nonkpsero." ".prison." | ".prisons."