Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

loading information from website

Hi

Very much a programming/DB novice here and would really like some assistance.

I am looking to pull information from the Dell website based on the Dell serial number of computers we have in stock.

I have found the part of the page I need, the issue I am having is calling the URL based on a variable loaded in another tab.

Any help would be gratefully appreciated

this is what I have at the moment:



let

LOAD
[Your Warranty],
[Your Warranty1],
[Your Warranty2],
[Your Warranty3]

FROM
$(url)(html, codepage is 1252, embedded labels, table is @57);

url = 'http://support.euro.dell.com/support/DPP/Index.aspx?c=ie&l=en&s=gen&ServiceTag=' & '$(BIOSSerialNum)';



3 Replies
Master II
Master II

You need to create kind of loop through a table with Serial-numbers, script might look like:



Serials:
LOAD
SerialNo
FROM
......;

FOR i = 0 TO NoOfRows('Serials') - 1

LET sURL = 'http://support.euro.dell.com/support/DPP/Index.aspx?c=ie&l=en&s=gen&ServiceTag=' & PEEK('SerialNo', i, 'Serials');

LOAD [Your Warranty],
[Your Warranty1],
[Your Warranty2],
[Your Warranty3]
FROM
$(sURL)
(html, codepage is 1252, embedded labels, table is @57);

NEXT i


HTH
Peter

Not applicable

Thanks Peter, I will give that a go and let you know how I get on

Not applicable

Hi Peter

Thanks for that, your suggestion worked. I am successfully pulling the information from the website.

Now, I just have to concentrate on applying the correct links.

Thanks again