Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
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...

Labels (1)
1 Solution

Accepted Solutions
rubenmarin
MVP
MVP

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

View solution in original post

4 Replies
giakoum
Partner - Master II
Partner - Master II

what is that for ?

Where RowNo() =0;

rubenmarin
MVP
MVP

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

Not applicable
Author

that is to load only header

Not applicable
Author

Tq Ruben