Load multiple files with criteria from folder

[JustinM]

Hi

I'm trying to load a number of files (Not all) from a folder but I'm doing something wrong as it is not loading. My script is:

for each ClaimsRegister in filelist('lib:/Folder/Monthly/Claims Register*.xlsx')

[Claims Register]:

LOAD

......

FROM [$(ClaimsRegister)]
(ooxml, embedded labels);

next ClaimsRegister

[neerajthakur]

Please share error screenshot to understand it better.

[JustinM]

Hi

It doesn't show an error. It just runs and completes the load whilst ignoring this load.

Thanks 

[neerajthakur]

Check file name is it correct? Use lib://Folder/Monthly/Claims Register*.xlsx

[NadiaB]

Hi @JustinM 

It looks like a forward slash is missing instead of lib:/something, it should be lib://something

Our documentation has some examples that could help, section "Example 2: Creating a list of files on disk"

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptCont...

Hope it helps!