problem in dynamic concatenation

[#1]

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

[swuehl]

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.