(ooxml, embedded labels, table is [Raw Data. 9.32 AM IST]) Table name issue in Qlik Sense!

[srini]

Hi Friends,

Very good Day!

I am loading files from local desktop every week.

Here tab name is different but the fields in the tab name are same. I would like to get the tab name from the current week file during the load to fill the table is [here]

(ooxml, embedded labels, table is [Raw Data. 9.32 AM IST])

right now my script is like this 

RawData:
LOAD
"Resource Code",
Resource,
"Resource Manager",
Status,
"Hours",
"OBS Unit Path",
"Billable Resource?",
"Week",
Email
FROM [lib://Clarity/RBWM Exceptions Report *.xlsx]
(ooxml, embedded labels, table is [Raw Data. 9.32 AM IST]);

after read few helps in the community I tried "biff" but it is not working also I  found there are few posts related to ODBC but not completely understanding. 

looking for some help!

Thanks in advance!

[Dataguy46]

Try this:

LOAD
"Resource Code",
Resource,
"Resource Manager",
Status,
"Hours",
"OBS Unit Path",
"Billable Resource?",
"Week",
Email
FROM [lib://Clarity/]
(ooxml, embedded labels, table is [Raw Data. 9.32 AM IST]);