break loop

Thu, 26 Jul 2012 07:40:46 GMT

Hi all,

i have created a table 'PathNames' where i have a number of paths to xls files.

Then i am looping through this table and read every xls from every directory i listed in 'PathNames':

FOR j = 0 to NoOfRows('PathNames') - 1

LET vPath = Peek('PathNames', $(j), 'PathNames');

For vYear = 2012 to $(vCurrentYear)

set vFunction = 'Function: R&D';

LOAD...

Problem is: When a path does not exist (because either the file or the target directory has been removed) my LOAD fails, because QV cant find the patch. ("Cannot open file... ")

How can i work around this - meaning: How can i skip paths that dont exist and continue with the next path in 'PathNames' ?

Hope, the issue is clear.

Thanks for some advise.

Re: break loop

Anonymous — Thu, 26 Jul 2012 07:50:44 GMT

You can use Set ErrorMode = 0;

Re: break loop

Thu, 26 Jul 2012 07:56:52 GMT

got it. thanks!

Re: break loop

Thu, 14 Mar 2013 11:49:17 GMT

Great! Thanks

topic Re: break loop in QlikView

break loop

Re: break loop

Re: break loop

Re: break loop