How do you capture a hyperlink url from a web page table?

[jmclaren]

Hi All,

I currently have a Qlikview file that in essence, calls up a web page and grabs the columns in a table. For simplicity, lets say the web page has a table with two fields - 'Date' and 'Agenda' and might look like this:

Date              Agenda

01/01/2017    Agenda_Jan17

01/02/2017    Agenda_Feb17

Currently my 'grab' loads two fields - 'Date' and 'Agenda', where 'Agenda' is the text as displayed above. On the source website table, the agenda item is hyperlinked and clicking on it would open the url i.e. 'http://somewhere.com/Agenda_Jan17.pdf' . What do I need to add to my script to create a third data item called, for instance, 'Agenda_URL' that grabs the url link address ?

Many thanks

Jim

[annafuksa1]

for Agenda_URL try =  'http://somewhere.com/' & Agenda  &'.pdf'

Date              Agenda                      Agenda_URL

01/01/2017    Agenda_Jan17            =  'http://somewhere.com/' & Agenda  &'.pdf'

01/02/2017    Agenda_Feb17

[jmclaren]

Hi Anna,

Thanks but my example wasn't good - the url could be anything so it is not possible to guess or construct it from the agenda text field. The hyperlink url itself would need to be read from the webpage.

Jim

[annafuksa1]

aaa,

so you need to download it

try (it is not working perfectly depends on website)

[jmclaren]

Anna,

My current script does use the 'Web files...' connect method, but it only pulls the display value for the field and I cannot see any way of getting to the underlying hyperlink url. Any other suggestions?

Jim

[annafuksa1]

you will need to take this field from data source as Qlikview is not able to read this, or try to use other tool.