7 Replies Latest reply: Jan 16, 2018 5:42 AM by Sandeep Roy RSS

    How to load data from web file dynamically

    Pascal Schwegler

      Hi Community,

       

      I would like to import data dynamically from company.info, so I have changed my settings.ini to StandardReload = 0.

      Now I can import dynamically right, but I cat message: 'Not found'

       

       

      My script is shown below:

       

      VENDOR:

      LOAD

           right('00000'&KVKNO&'0000',12) as KVKNO,

      FROM [lib://Data/VENDOR.csv]

      (txt, codepage is 28591, embedded labels, delimiter is '~', msq)

      where KVKNO <> '';

       

      KVKCOUNTER:

      LOAD DISTINCT KVKNO as KVKNUM,

      RowNo() as RowNo

      RESIDENT VENDOR;


      let kvkCounterRows = NoOfRows('KVKCOUNTER');


      for i=1 to 10

      //for i=1 to $(kvkCounterRows)


      let KVKNO = peek('KVKNUM',$(i),KVKCOUNTER);

       

      KVK:

      LOAD

          @1,

          @2

      FROM [https://company.info/id/$(KVKNO)]

      (html, codepage is 1252, no labels, table is @1)

      where @1 = 'KvK';


      I hope anybody can help me.

      Thank you in advance.

       

      Grtz, Pascal