Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am unable to fetch filename from xlsx files in QlikSense. but it fetches the filename form xls file.
below is the script which i have used:
LOAD
CIN,
COMPANY_NAME,
COMPANY_CLASS,
COMPANY_CATEGORY,
COMPANY_SUBCAT,
COMPANY_STATUS,
DATE_OF_REGISTRATION,
REGISTERED_STATE,
"Authorized Capital (Rs.)",
"PAIDUP_CAPITAL (RS.)",
PRINCIPAL_BUSINESS_ACTIVITY_CODE,
REGISTERED_OFFICE_ADDRESS,
EMAIL_ID,
"LATEST ANNUAL REPORT FILING FY END DATE",
"LATEST BALANCE SHEET FILING FY END DATE",
FileName() as File_Name
FROM [lib://Company Master Data/Andaman_Nicobar_Islands_2016.xls]
(biff, embedded labels, table is Sheet2$);
Please help!
Ah, sorry, seems I've tested on an older version.
Maybe the issue is related to
Works for me also using an .xlsx file.
What do you get instead of the file name? NULL?
Could you post the script that does not work? (and a sample xlsx file that you are trying to load)
On which version of QS are you?
Doesn't seem to work for me either.
Example xlsx is attached and i'm using the QS version of the image below.
Script im using
x:
LOAD
A,
B,
C,
FileName() as FileName,
FilePath() as FilePath,
FileDir() as FileDir,
FileExtension() as FileExtension,
FileSize() as FileSize,
FileTime() as FileTime
FROM [lib://Desktop/Sample.xlsx]
(ooxml, embedded labels, table is Plan1);
Ah, sorry, seems I've tested on an older version.
Maybe the issue is related to