Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator II
Creator II

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

Hi there,

How to I get rid of the T2-1

ashmitp869_0-1648676965142.png

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;

Labels (1)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Unqualify WeeklyCovidNo.WeekN;