topic Using for i loop in QlikView

Using for i loop

zekazak — Thu, 27 Oct 2011 16:34:39 GMT

Hi,

I've stuck with the loop in my load script. Data source is the web file (html).

code looks like this:

CLIENTID:

QUALIFY *;

for i=1 to 3

LOAD clientid

FROM

[http://www.zzzz.com/page/$(i)]

(fix, codepage is 1252)

where clientid <> null();

This code works fine but I expect to receive one table named 'CLIENTID' with all the clientid's from three different web pages. When I run my code it creates 3 separate qv tables: 'CLIENTID' then '1' and '3'. Is there any way to loop the data sources and get all the data in ONE qv table ('CLIENTID' in this example)?

Any help will be highly appreciated.

Thank you in advance,

~Sergejs

Using for i loop

swuehl — Thu, 27 Oct 2011 17:12:13 GMT

I would suggest removing the qualify statement and then putting the table name CLIENTID before the LOAD, like

for i=1 to 3

CLIENTID:

LOAD clientid

FROM ...

Hope this helps,

Stefan

Using for i loop

zekazak — Fri, 28 Oct 2011 08:06:21 GMT

Hi Stefan,

It does work. Brilliant. Thank you very much!

Best Regards,

~Sergejs