topic Re: Filesize Function not working in QlikView

Filesize Function not working

Wed, 07 Jan 2015 09:53:21 GMT

Hi Experts,

(FileSize('$(vDataFolder)*.csv')>0) then
// Loop through each file under DataSource folder
for each vFiles in filelist('$(vDataFolder)*.csv')
//Read the file name and time
tmp:
LOAD FileName() as filename, FileTime() as filetime
FROM [$(vFiles)](txt, codepage is 1252, explicit labels, delimiter is ',', msq) Where RowNo() =0;

i have my code for extracting csv files from a floder like this.It is working fine till last day.

i dnt know what happen i am not able to load any file ,,,script is terminated at the first condition itself

Attached is the log FYI...

Re: Filesize Function not working

giakoum — Wed, 07 Jan 2015 10:03:05 GMT

what is that for ?

Where RowNo() =0;

Re: Filesize Function not working

rubenmarin — Wed, 07 Jan 2015 10:04:20 GMT

Hi Sruti, maybe vDataFolder needs to end with a '\'?

Re: Filesize Function not working

Wed, 07 Jan 2015 10:13:24 GMT

that is to load only header

Re: Filesize Function not working

Wed, 07 Jan 2015 10:19:53 GMT

Tq Ruben