Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

pascalschwegler
New Contributor III

How to load data dynamically from website

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

1 Reply

Re: How to load data dynamically from website

When occured the error - already by the first iteration or later? If later it would mean that your script is generally working but a certain combination of KVKNO and table @1 isn't available. If it's by the first iteration you should check if the variable KVKNO contained a valid content, for example with:

trace '$(KVKNO)';

If this looked ok. you should check if your load-statement is right - just create a load-statement with the wizard of one and/or several pages and compare this result with your code - maybe there are differences.

- Marcus

Community Browser