2 Replies Latest reply: Oct 28, 2011 4:06 AM by Sergejs Kazakevics RSS

    Using for i loop

    Sergejs Kazakevics

      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();

      NEXT

       

      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