Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Filesize Function not working


Hi Experts,

if

(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...

1 Solution

Accepted Solutions
rubenmarin
Not applicable

Re: Filesize Function not working

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

4 Replies
giakoum
Not applicable

Re: Filesize Function not working

what is that for ?

Where RowNo() =0;

rubenmarin
Not applicable

Re: Filesize Function not working

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

Not applicable

Re: Filesize Function not working

that is to load only header

Not applicable

Re: Filesize Function not working

Tq Ruben