Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
How to I get rid of the T2-1
Here is my script-
qualify *;
unqualify _Date,"Facility Identifier","FacilityCode-Date";
WeeklyCovidNo:
LOAD
Date(Date#([Today's date],'M/D/YYYY'),'D/M/YYYY') as _Date,
"Facility Identifier",
[FacilityCode-Date],
"COVID +ve patients in ICU - primarily receiving treatment for COVID" as "ICU COVID (Primary)",
"COVID +ve patients in ICU – for other reasons" as "ICU COVID (Incidental)",
"COVID +ve patients in wards – in hospital primarily receiving treatment for COVID" as "Wards COVID (Primary)",
"COVID +ve patients in wards - in hospital primarily for non-COVID reasons" as "Wards COVID (Incidental)"
FROM [lib://Weekly COVID numbers1.xlsx]
(ooxml, embedded labels, table is Form1) ;
Unqualify WeekN;
T2:
Load
Distinct _Date,
AutoNumber(_Date)-1 as WeekN
Resident WeeklyCovidNo;
left join(WeeklyCovidNo)
LOAD
_Date,
WeekN as "WeeklyCovidNo.WeekN"
Resident T2;
drop table T2;
Unqualify WeeklyCovidNo.WeekN;