topic load script for each problem in QlikView

load script for each problem

Tue, 31 May 2016 09:19:50 GMT

Hello,

I am trying to modify a load script where we have for each and if-condition.

It goes through all the qvd files. And I don't want it to load qvd files that are not from the year 2015 or 2016 and forward.

So we have

for each file in filelist(folderpath & '\*')

if lower(right('$(v.found.file)',3))='qvd' then

etc

That works

But if I put

for each file in filelist(folderpath & '\*')

if lower(right('$(v.found.file)',3))='qvd'

AND num(lower(left('$(v.found.file)',4))) > num(2014) then

it does not work, it skips the whole thing!

What is wrong and how can I do double if?

Cheers,

Niko

Re: load script for each problem

tamilarasu — Tue, 31 May 2016 09:22:47 GMT

Try,

AND left('$(v.found.file)',4 )> 2014 then

Re: load script for each problem

Tue, 31 May 2016 09:24:44 GMT

Hi Niko,

There is syntax error. Opening brackets count and close brackets counts are not matched.

num(lower(left('$(v.found.file)',4))) > num(2014)

try this.

-Joyson G

Re: load script for each problem

Tue, 31 May 2016 09:24:48 GMT

Nope, it did not work either.. Still skipping the script phase.

Re: load script for each problem

Kushal_Chawda — Tue, 31 May 2016 09:25:51 GMT

'$(v.found.file)' instead '$v.found.file)'

Re: load script for each problem

Tue, 31 May 2016 09:28:14 GMT

Yeah, there was a typo.. But it isn't still working

Re: load script for each problem

Kushal_Chawda — Tue, 31 May 2016 09:33:30 GMT

what is Filename?

Re: load script for each problem

Tue, 31 May 2016 09:35:19 GMT

They are all like

2013-06.QVD

2013-07.QVD

and so on

Re: load script for each problem

Kushal_Chawda — Tue, 31 May 2016 09:39:53 GMT

try this

for each vFile in filelist(folderpath & '\*')

if lower(right('$(vFile)',3))='qvd' and subfield(subfield('$(vFile)','\',-1),'-',1) >=2015 then

...

end if

Re: load script for each problem

tamilarasu — Tue, 31 May 2016 09:40:49 GMT

I am not sure why this is not working for you. I did a test and it's working.

Re: load script for each problem

Tue, 31 May 2016 09:48:58 GMT

That did the trick! Wow.. What happens in that subfield()-set?

Thank you!

Cheers,

Niko

Re: load script for each problem

Kushal_Chawda — Tue, 31 May 2016 09:54:23 GMT

lets say you have value in vFile as D:\Data\QVD\2015-05.qvd

inner subfield('$(vFile)','\',-1) - picks up 2015-05.qvd and our subfield picks up the 2015 from (2015-05.qvd)

Re: load script for each problem

Anonymous — Tue, 31 May 2016 09:57:13 GMT

Hi Niko,

It is more easy:

for each vFile in filelist(folderpath & '\*.qvd')

if subfield(subfield('$(vFile)','\',-1),'-',1) >=2015 then

....

end if

Kind regards.

Re: load script for each problem

Tue, 31 May 2016 09:58:11 GMT

Nice! Have to remember this subfield() in the future, seems to be very useful.

Thanks a lot again

Always learning new things here about QlikView.

Cheers,

Niko

Re: load script for each problem

Kushal_Chawda — Tue, 31 May 2016 10:01:48 GMT

Yeah, Qlik community is gr8.

Re: load script for each problem

Tue, 31 May 2016 10:02:57 GMT

Yes, it surely is!