Excluding empty file while loading

[khan_imran]

Hello All,

I am having thousands of Excel files which contains empty files as well.

My requirement is that i want to ignore all files which are completely empty.

Kindly suggest.

Regards,

Imran Khan

[tomasz_tru]

You can set error mode to 1 and read all files.

http://help.qlik.com/en-US/sense/2.1/Subsystems/Hub/Content/Scripting/ErrorVariables/ErrorMode.htm

[sasiparupudi1]

May be check the file size

For each File in Filelist('C:\Test\*.xlsx')

Let vFileSize=FilelSize ('$(File)');

If $(vFileSize)>8000 then

Load stmt

End if

Next