Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Set vConcatenate = ;
sub ScanFolder(Root)
for each FileExtension in 'csv'
for each FoundFile in filelist( Root & '\*.' & FileExtension)
$(vConcatenate)
FileList:
LOAD distinct @3 as smsisdn,
(@1/86400)+25569 as stimestamp,
@2 as snetworkid
, '$(FoundFile)' as SourceFile
FROM [$(FoundFile)] (txt, codepage is 1252, no labels, delimiter is ',');
Actual:
load smsisdn, max(stimestamp) as sTimestampMax, firstsortedvalue(snetworkid, stimestamp) as snetworkid
resident FileList
group by smsisdn;
//drop table FileList;
Set vConcatenate = NoConcatenate;
next FoundFile
next FileExtension
end sub
Call ScanFolder(path) ;
*/
I am getting error in the highlighted part and script execution is failed. please help me how to resolve this
I think the inner join of your lat / long table might prevent the actuals table from proper concatenating.
Try to join the table at the very end of your sub, after you've concatenated all actual tables.