Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
It seems to me the FinalFileList has the same number and names of fields of the FileList table
Qlik will concatenate Final.... to FileList
add a noconcatenate
Thanks it works fine