Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Hi Sruti, maybe vDataFolder needs to end with a '\'?
what is that for ?
Where RowNo() =0;
Hi Sruti, maybe vDataFolder needs to end with a '\'?
that is to load only header
Tq Ruben