Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jmclaren
Contributor III
Contributor III

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

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

5 Replies
annafuksa1
Creator III
Creator III

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
Contributor III
Contributor III
Author

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
Creator III
Creator III

aaa,

so you need to download it

try (it is not working perfectly depends on website)

Untitled.png

jmclaren
Contributor III
Contributor III
Author

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
Creator III
Creator III

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