Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Why don't you use "for each" and test the filesize before doing the load?
Why don't you use "for each" and test the filesize before doing the load?
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.
for each file in filelist('*.txt')
if filesize(file) > 768 then
LOAD ...
Thanks Daniel, that's what I was looking for.
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?