That' fine Pascal. Just check in that file whether you have placed it rightly or not.
You have to Peek @1 from that table and set to vURL.
If that is fine then try to set your URL as vURL='https://company.info/id/$(KVKNO' @1
Then Load the query at the end FROM $(vURL).
I hope it will help you.. otherwise give the screenshot of your settings.ini file.
Thank you for your reply. Unfortunately I get errors "not found"
Now my script is as follows:
Set ErrorMode = 0;
Set vUrl = 'https://company.info/id/$(KVKNO)';
right('00000'&KVKNO&'0000',12) as KVKNO,
FROM [lib://Data/VENDOR - Copy.csv]
(txt, codepage is 28591, embedded labels, delimiter is '~', msq)
where left(VENNO,2) <> '--' and KVKNO <> '';
LOAD DISTINCT KVKNO as KVKNUM,
RowNo() as RowNo
let kvkCounterRows = NoOfRows('KVKCOUNTER');
for i=0 to 10
//for i=0 to $(kvkCounterRows)
let KVKNO = peek('KVKNUM',$(i),KVKCOUNTER);
@1 as 'KVKCOLUMN',
trim(@2) as 'KVKNO',
(html, codepage is 1252, no labels, table is @1)
where @1 = 'KvK';
@1 as 'SBICOLUMN',
TRIM(left(@2,INDEX(@2,' -'))) as 'SBICODE',
RowNo() as 'Key'
(html, codepage is 1252, no labels, table is @2)
where @1 = 'SBI (KvK)';
Do you recognize inaccuracies or some?