topic Empty Files in QlikView

Empty Files

Anonymous — Mon, 14 May 2012 18:55:01 GMT

We currently load multiple files from a directory into a single QVW file but periodically we get sent empty documents from our customer. Unfortunately when the file is empty half the columns are missing and load load process fails, is there anyway to tell QlikView to ignore these files during the load process?

I have already confirmed these files are always 512bytes in size and actually tried the following but it still seems to load the entire file and then fail:

Load Field1,

Field2,

Field3,

Filed4

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

Where FileSize()>768;

Empty Files

danielrozental — Mon, 14 May 2012 19:45:33 GMT

Why don't you use "for each" and test the filesize before doing the load?

Empty Files

Anonymous — Tue, 15 May 2012 17:19:22 GMT

How would I use For Each? I like the idea but can't see the syntax to use a condition such as Where FileSize() in conjunction with For Each.

Empty Files

danielrozental — Tue, 15 May 2012 17:38:32 GMT

for each file in filelist('*.txt')

if filesize(file) > 768 then

LOAD ...

Empty Files

Anonymous — Tue, 15 May 2012 19:41:17 GMT

Thanks Daniel, that's what I was looking for.

Re: Empty Files

rajni_batra — Wed, 27 Jun 2012 07:59:59 GMT

Daniel

i have the path

LET Filename='C:\Documents and Settings\5481\Desktop\Importdatafromsharepoint\Rev Call Summary Sheet_'&$(a)&'.xlsx';

and excel comes on weekly basis on random day.

so i want a daily reload how can i implement this using for each loop?