Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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