Skip to main content
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