Hello,
My months are being pulled in alphabetical order which is then causing me errors when I try and user "MaxString(Month)" and so on. I tried a few things but it's not working in the script end. I have a crosstable so I'm not sure if maybe I can add it in there?
TEMP2:
Crosstable([Facility Temp], [Score Temp], 23) //if any row is added into the excel I need to uyp the numbere here
LOAD
[Record ID],
AHJ,
"Date",
"Month",
"Year",
"Prior TJC Survey",
"Consultants",
AMP,
"TOP 10",
[Top 10 Flag],
"SAFER Status",
Inventory,
[New / Revised],
DOC,
FSA,
"Management Plan",
[EC-LS-EM],
[EC-LS-EM Long],
STANDARD,
EP#,
[CHAPTER EP#],
[ELEMENT OF PERFORMANCE],
"UMHC SYSTEM",
// Chapter,
"UMHC SCCC",
"UHealth Tower",
"UMHC BPEI",
"UMHC LFMC",
"UMHC Radiology",
"UMHC Applebaum",
"UMHC Ear Institute",
"UMHC Pain Clinic",
"UMHC Safie",
"UMHC IR Clinic",
"UMHC Coral Spring",
"UMHC Deerfield",
"UMHC Hollywood",
"UMHC Kendall",
"UMHC Plantation",
"UMHC Marlin Park"
RESIDENT TEMP;
Drop Table TEMP;
[ALL DATA]:
LOAD RecNo() as ID,
Replace([Facility Temp],'UMHC ','') as Facility,
//If([Score Temp]=0,'NULL',[Score Temp]) as Score,
If([Score Temp]=0,'N/A',[Score Temp]) as Score,
*
Resident TEMP2;
Drop Table TEMP2;
Drop Fields [Facility Temp], [Score Temp];
[UHealth Facility]:
LOAD
"UHealth Facility" as Facility,
Latitude,
Longitude,
GeoMakePoint(Latitude,Longitude) as GeoPoint,
Address,
City,
State,
ZIP
FROM [lib://UHealth Facility (uhealth_54171224)/UHealth Facility.xlsx]
(ooxml, embedded labels, table is [UHealth Facility])
Where NOT IsNull(Latitude);
