extracting part of excel file name in QLIK

arusanah — Sat, 17 Sep 2022 12:36:43 GMT

Hello Qlikers,

when i load a file from a location and need to get table information from file type part of file.

e.g below is my file . i need to extract Sheet1 from file type to store in a variable.

FROM [lib://AttachedFiles/abc.xlsx]
(ooxml, embedded labels, table is Sheet1);

Any help is much appreciated.

thanks

Arusana

topic extracting part of excel file name in QLIK in App Development