Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
aaa,
so you need to download it
try (it is not working perfectly depends on website)
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
you will need to take this field from data source as Qlikview is not able to read this, or try to use other tool.