Empty Files

[Anonymous]

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;

[danielrozental · Accepted solution]

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

[Anonymous]

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.

[danielrozental]

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

     if filesize(file) > 768 then

        LOAD ...

[Anonymous]

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

[rajni_batra]

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?