topic for...next cycle problem in QlikView

for...next cycle problem

Thu, 07 Jan 2010 09:46:15 GMT

Hello, everybody.

I have a table [URLS] with a field [URL], which contains the web address.

I want to make a script, which would proceed through this table and load a certain data, for example, age information from web addresses in each field.

I made script similar to this:

set i = 0;

for i = 0 to 1000

let v_url = PEEK('URL',i,'URLS');

[Data]:

LOAD [Age:] as [Age]
FROM
$(v_url)
(html, unicode, embedded labels, table is @4);

next i

Script works only for the first iteration. After that it for some reason does not recreate v_url variable, it is empty and script fails.

What am I doing wrong?

Thanks in advance!

for...next cycle problem

Miguel_Angel_Baeyens — Thu, 07 Jan 2010 10:00:25 GMT

Hello,

Try

LET v_url = PEEK('URL, $(i), 'URLS')

for...next cycle problem

Thu, 07 Jan 2010 10:04:46 GMT

Same result, unfortunately.

for...next cycle problem

Miguel_Angel_Baeyens — Thu, 07 Jan 2010 10:37:18 GMT

First, sorry for my syntax errors in my previous post. Have you tried with

SET v_url = PEEK('URL', $(i), 'URLS');

instead of LET?

for...next cycle problem

Thu, 07 Jan 2010 11:33:10 GMT

To variable v_url in this case is assigned the string ' PEEK('URL', $(i), 'URLS')' itself, instead of the value from URL field.

for...next cycle problem

Miguel_Angel_Baeyens — Thu, 07 Jan 2010 11:45:58 GMT

Indeed. That's what you assign, but then it will be evaluated via macro expansion with $(v_url). LET evaluates expression before being assigned. As far as I understand, you want to look for the name of the record. So thus should work.

for...next cycle problem

Thu, 07 Jan 2010 11:51:51 GMT

Well, it did not evaluate. I received the error message, which notified that table PEEK can' t be opened (instead of web address there was PEEK('URL', $(i), 'URLS') string in FROM part of LOAD statement).

for...next cycle problem

Thu, 07 Jan 2010 12:09:54 GMT

I've had problems using peek in situations like this. Can't really remember why but I've used fieldvalue instead successfully.
Something like this:
let noOfRows = noOfRows('URLS');
for i=1 to $(noOfRows)
let v_url = fieldvalue('URL', $(i));
LOAD [Age:] as [Age]
FROM
$(v_url)
(html, unicode, embedded labels, table is @4);
next

Note that fieldvalue returns the value from the field itself, not the value on a specific row within the table.
If you have duplicate values in the URL field you won't get the expected result.
I've solved this by adding a rownumber to the URL field to create unique values and then remove the rownumber when reading from the url.

/Fredrik

for...next cycle problem

Thu, 07 Jan 2010 12:22:02 GMT

This worked, thanks!

Still, it was a strange problem.