find latest folder in network folder in qlikview load script

mail2bsk — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to find latest folder in Network folder and load files from that folder using qlikview load script. wondering how to automate process with changing dates manually.

For example

Network folder : "\\dev\"

Folders:

20160201 - folder 1

20160601 - folder 2

Files in folder 20160601 will be

20160601_abc1.xls

20160601_abc2.xlx

Load script is

load *

from "\\dev\20160601\20160601_*.*";

Thanks

Re: find latest folder in network folder in qlikview load script

tamilarasu — Tue, 02 Aug 2016 04:55:41 GMT

Hi,

Try this,

Set vBaseDirName = '\\Dev\*';
 
 FOR Each vSubFolder in DirList(vBaseDirName)
 
 Folders:
 LOAD
 '$(vSubFolder)'  as FolderPath,
 Date(Date#(Subfield('$(vSubFolder)' ,'\', -1),'YYYYMMDD'), 'YYYYMMDD') as YearMonth
 AutoGenerate 1;
 NEXT vSubFolder
 
 Latest:
 NoConcatenate
 Load FolderPath,
 YearMonth 
 Resident Folders Order by YearMonth desc;
 
 Let vLatestFolder = Peek('FolderPath',0, 'Latest');
 
 DROP Table Folders, Latest;
 
 LatestData:
 Load *
 from $(vLatestFolder)\20160601_*.*;

topic Re: find latest folder in network folder in qlikview load script in QlikView

find latest folder in network folder in qlikview load script

Re: find latest folder in network folder in qlikview load script