topic Re: How do you capture a hyperlink url from a web page table? in QlikView

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

jmclaren — Mon, 06 Mar 2017 11:52:41 GMT

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

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

annafuksa1 — Mon, 06 Mar 2017 13:38:42 GMT

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

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

jmclaren — Mon, 06 Mar 2017 13:44:43 GMT

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

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

annafuksa1 — Mon, 06 Mar 2017 13:58:17 GMT

aaa,

so you need to download it

try (it is not working perfectly depends on website)

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

jmclaren — Mon, 06 Mar 2017 15:09:45 GMT

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

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

annafuksa1 — Mon, 06 Mar 2017 16:00:38 GMT

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