This content has been marked as final. Show 2 replies
I'm having an issue in extracting the particular txt file from the task log folder. So, I got the below sub routine from community and modified accordingly to do my task as below,
for each FileExtension in 'txt'
for each FoundFile in filelist( Root & '\*.' & FileExtension)
LOAD '$(FoundFile)' as SourceFile,
FileTime( '$(FoundFile)' ) as Filetime
Set vConcatenate = Concatenate;
for each SubDirectory in dirlist( Root & '\*' )
Step 1 : Call the sub routine to extract all the txt files from the root folder (including sub folders).
Call ScanFolder ('myfolder\Log');
Step 2 : Do a resident load from the sub routine result set table and then filter the data based on the task name.
WHERE SourceFile LIKE '*Reload_Task_Check';
But after this step 2 I'm not getting the desired result. Only the FileList table is there, but not the FinalFileList table is generated.
Can you please help me here.