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

    Using for i loop

    Sergejs Kazakevics



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

      code looks like this:



      QUALIFY *;

      for i=1 to 3

      LOAD clientid



      (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,