Help need in scripting

[ashmitp869]

Hi there,

Please help me to write script-

Here is the chart that I need for my report.

I am writing the script-

HCW:
LOAD
FileName() as HCW.FileName,
if(rowno()=1, 1,0) as count_active,
if(rowno()=2, 1,0) as count_total_isolation,
if(rowno()=3, 1,0) as count_total_community,
Nursing,
Medical,
"Allied Health",
"Scientific/Technical",
"Admin/ Corporate",
"Other",
MakeDate(Year(FileName()),Month(FileName()), Day(FileName())) as Filedate
FROM [lib://QVD COVID19/SitRep/NSLHD HWC Exposures/*.xlsx]
(ooxml, embedded labels, table is [OPTION 2]);

This is what I got until now -

I need  the Nursing , Medical,
"Allied Health",
"Scientific/Technical",
"Admin/ Corporate",
"Other" values in my qliksence table

[hic]

You should probably load your data using the Crosstable prefix, so that you will get the labels Nursing, Medical, "Allied Health", "Scientific/Technical", "Admin/ Corporate", and "Other" into one single field.

See more on https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083