How to trace file with error while loading data in Qlik Sense

[Aditya_Chitale]

Hi All,

I have multiple files stored at a location and I am reading them all at once using below method:

Load

from [lib://Supply Chain Files/File_Forecast_*.xlsx]

(ooxml, embedded labels, table is Sheet2)

But I am getting load error one one of the files. Can I trace my any means, the name of the file which is throwing this error ?

I tried using for each loop combined with fieldValueList function but I am unable to see the file name in trace command

Any help would be greatly appreciated.

Regards,

Aditya

[vikasmahajan]

Hi,

You can mention in script like :

Trace $(vfilename) ;

this will show you which file is troubling you.

Vikas

[Andrei_Cusnir · Accepted solution]

Hello,

You can do the following use case scenario:

For Each File in FileList('lib://Folder/File_*.xlsx')

   trace Loading file: $(File);
   LOAD
       Data,
       Value
   FROM [$(File)]
   (...);
   
next File;

With this, you are going to trace every single file that is being processed each time and when the error occurs it will also show you on which file exactly. This is what I have on my side:

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members. 
 

[Aditya_Chitale]

Hi @Andrei_Cusnir 

Thanks ! It worked. Just replaced FieldValueList() with FileList().

Regards,

Aditya