Unable to Load all files in Qlik Sense with *

[dataexplorermytyles]

Hi,

I have two files in my google drive with same structure.

I am trying to load both of these files at once in Qlik Sense, but getting file not found error.

If I load them separately, it works fine. Tried all the tricks that I could, but '*' is not working like it does in Qlik Sense.

Any tips?

Thanks,

M

#QlikSense

[Zapparoli]

Hello,

You can use a for loop to load all the files in the folder, like so:

  For each vFileName in Filelist ('lib://YourPath/*.xlsx')
      Load *,
         '$(vFileName)' as FileName
      From [$(vFileName)];
   Next vFileName

Check this great documentation made by Hic that explains this Function:

https://community.qlik.com/t5/Design/Loops-in-the-Script/ba-p/1473543

-Zapparoli