How do you capture a hyperlink url from a web page table?
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:
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 ?
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.
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?