Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I am trying to load a file from a folder where the sheet name inside the file has a changing timestamp. The load looks like:
FROM [lib://LMT_BigFix Folder (ams_xbbnwhr)/SoftwareClass.xlsx](ooxml, embedded labels, table is [SoftwareClass20200303]);
How do I create a variable within the table pull?
check this links.
https://community.qlik.com/t5/New-to-QlikView/loading-all-sheets-data-from-excel/td-p/673784
https://community.qlik.com/t5/QlikView-Scripting/need-to-load-all-the-sheets-in-excel-at-time/m-p/13...
https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-load-all-sheet-in-a-excel-simultaneously-usin...