topic Re: Loading taskLog files in Qlikview in QlikView

Loading taskLog files in Qlikview

timsaddler — Thu, 05 Feb 2015 16:03:41 GMT

hello all,

Is it possible to load these TaskLog.txt files using a wildcard scenario straight into Qlikview ?

I'm trying to compare the run time of a Qlikview qvw as it needs to always be less than 3 minutes.

many thanks

\\Qlikview1\Qlikview_Files\DistributionService\2\Log\20150204\000508 - Reload of Development Qvd_Rollcall_S1 - RollCall Extract\TaskLog.txt

\\Qlikview1\Qlikview_Files\DistributionService\2\Log\20150204\000732 - Reload of Development Qvd_Rollcall_S1 - RollCall Extract\TaskLog.txt ;

Anonymous — Thu, 05 Feb 2015 16:11:45 GMT

You should be able to load all files using a star as a wildcard.

Eg: \\Qlikview1\Qlikview_Files\DistributionService\2\Log\20150204\*Reload of Development Qvd_Rollcall_S1 - RollCall Extract\TaskLog.txt ;

I guess the more advanced scenario starts with having to look into each of the folders (pr day) to load the files.

Look into Loading data from multiple xls-files from folder with subfolder to see an example of how to loop through multiple folders and load files.