Hi
I am trying to load 5 or 6 HTML tables from the interweb but due to their nature the name of the tables will change.
This is my script:
FOR i = 0 to 5
LET vYear$(i) = year(now()) - $(i);
NEXT i
LET i = nothing;
SET sBankHolsURLDotGov = 'https://www.gov.uk/bank-holidays/';
// ******************************************************** ************************ \\
BankHols:
LOAD
*,
left($(vYear0),index($(vYear0),chr(32))-1)*1 as BankHolidayDay,
left([2014] ,index([2014] ,chr(32))-1)*1 as BankHolidayDay_Hardcoded
;
LOAD
*
// $(vYear0) //[2014],
// $(vYear0)&'2', //[20142]
FROM
[https://www.gov.uk/bank-holidays/](html, codepage is 1252, embedded labels, table is @1)
;
As you can see, I would like to use variables to refer to Field.
Also I tried to replace the "@1" section of the (html, codepage... ) From statement with a dynamic variable but this also fails. Is all of this impossible or am I just failing due to incorrect syntax?
Thanks
Oli
