topic Re: Looping Error in Qlikview in QlikView

Looping Error in Qlikview

Anonymous — Fri, 09 Feb 2018 06:16:14 GMT

Hi All,

i want to pick up the Recent file from the Given folder and coding is picking up the recent file as expected

but when i removed the recent file

for example: i have removed the file which is having the data file of - sample_Download_20180209

when i reload the data Qlikview throwing the Error "Cannot open file '\\Naren\in\sample\sample_Download_20180209.CSV'The system cannot find the file specified."

My Doubt is When i removed the Current data file it need to fetch the previous data file from the folder sample_Download_20180208

Coding as Follow:

Let vFilePath ='\\Naren\in\sample\sample_Download_';

FOR EACH file in FileList('$(vFilePath)*.csv'); // Loops each excel file in the given Folder t

LET vYears = mid(file,26,27);

LET vDates = mid(vYears,14,14);

LET vSM = Rangemax(vDates,vSM);

Sample:

ID,

Name,

Desg

FROM

[$(vFilePath)$(vSM).csv]

(txt, utf8, embedded labels, delimiter is '|', no quotes, no eof)

loveisfail‌pcammaert‌stalwar1‌luismadriz‌elixir.seajet‌qlikcheepirishetty‌jontydkpi‌kaushalkaushik‌

Re: Looping Error in Qlikview

tamilarasu — Fri, 09 Feb 2018 06:46:01 GMT

Hi,

Try this,

Let vFilePath ='\\Naren\in\sample\sample_Download_';

Let vSM =;

FOR EACH file in FileList('$(vFilePath)*.csv'); // Loops each excel file in the given Folder t

LET vYears = mid(file,26,27);

LET vDates = mid(vYears,14,14);

LET vSM = Rangemax(vDates,vSM);

Sample:

ID,

Name,

Desg

FROM

[$(vFilePath)$(vSM).csv]

(txt, utf8, embedded labels, delimiter is '|', no quotes, no eof)

Re: Looping Error in Qlikview

tamilarasu — Fri, 09 Feb 2018 06:48:22 GMT

You can also try,

Let vFilePath ='\\Naren\in\sample\sample_Download_';

Let vSM =;

FOR EACH file in FileList('$(vFilePath)*.csv'); // Loops each excel file in the given Folder t

LET vDates = Replace(Subfield(SubField(file,'\',-1),'_',-1),'.csv','');

LET vSM = Rangemax(vDates,vSM);

Sample:

ID,

Name,

Desg

FROM

[$(vFilePath)$(vSM).csv]

(txt, utf8, embedded labels, delimiter is '|', no quotes, no eof)

Re: Looping Error in Qlikview

tresB — Fri, 09 Feb 2018 06:51:37 GMT

Have a look at this : Load Latest file from a folder into Qlikview

Re: Looping Error in Qlikview

stabben23 — Fri, 09 Feb 2018 06:54:45 GMT

Hi,

what is expected output here?

Have you test this in a texbox With mid function?

LET vYears = mid(file,26,27); mid(file,1,26) gives you the Whole filename

LET vDates = mid(vYears,14,14);

LET vSM = Rangemax(vDates,vSM);