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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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...

1 Solution

Accepted Solutions
rubenmarin

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

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

Not applicable
Author

that is to load only header

Not applicable
Author

Tq Ruben