topic Re: Wild Card in Load Script in Move to Qlik Cloud Analytics

Wild Card in Load Script

wttaryde — Tue, 27 Jan 2026 10:45:26 GMT

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.

Re: Wild Card in Load Script

Vishal_Gupta — Mon, 28 Aug 2023 08:28:57 GMT

@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.

Re: Wild Card in Load Script

wttaryde — Mon, 28 Aug 2023 19:14:23 GMT

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]);

Re: Wild Card in Load Script

Jul_K — Thu, 16 May 2024 13:28:38 GMT

Hi Wttaryde,

have you found already a solution to this topic? I am having the same problem.

Re: Wild Card in Load Script

wttaryde — Thu, 16 May 2024 14:27:02 GMT

I found that there is no solution. That last time I checked it was clearly stated that the wild card didn’t work. I haven’t looked in a while because we changed the data files and I no longer needed the wildcard.