topic Re: Excluding empty file while loading in QlikView

Excluding empty file while loading

khan_imran — Sat, 12 Aug 2017 18:41:54 GMT

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 — Sat, 12 Aug 2017 18:58:43 GMT

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

sasiparupudi1 — Mon, 14 Aug 2017 11:33:53 GMT

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