Help needed in the script to get rid of prefix table name ?

[ashmitp869]

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;

[rwunderlich]

Unqualify WeeklyCovidNo.WeekN;