Can this be dynamic?

Tue, 25 Feb 2014 12:26:35 GMT

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

Re: Can this be dynamic?

Wed, 26 Feb 2014 08:32:05 GMT

Due to the moderation and a mix up this post was duplicated. So, I am closing this one. If you have any ideas please could you reply on this thread Can this be dynamic

Thanks

Oli

topic Can this be dynamic? in QlikView

Can this be dynamic?

Re: Can this be dynamic?