Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have been using client managed Qlik Sense for a while. I have load scripts that work just fine. They aren't working in Qlik Cloud. The problem is the wild card in the file name:
LOAD
fields...
FROM [lib://...path.../../TD/2023 TD Quest - AM Asset Mgmt*.xlsx]
(ooxml, embedded labels, header is 1 lines, table is [AM Asset Management]);
Without the wild card it loads fine, but not with it. All the files in the directory have a slightly different ending. Not sure to work around this.
@wttaryde unfortunately qlik cloud does not support wildcard match in script.
Though you can write a simple loop by creating a variable and iterating the values in it based on your logic.
And yet on the website it clearly shows wild cards in the instructions. Any suggestions on this? I need to replace the last part of the file name 'APS - 21'. All my files end differently.
FOR EACH File IN FileList('lib://Dropbox - debi.mclain@1qconsulting.com/1QC Benchmarking/2023 Benchmarking/TD/Data Output/TD/2023 TD Quest - AM Asset Mgmt - APS - 21.xlsx')
ResponseTable:
CrossTable(Year, Response, 17)
LOAD
Field1,
Field2,
Field3
FROM $(File)
(ooxml, embedded labels, header is 1 lines, table is [AM Asset Management]);
Hi Wttaryde,
have you found already a solution to this topic? I am having the same problem.