Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
André
Contributor III
Contributor III

[Qlik Sense Cloud] Load HTML code from a webpage

How do I load the HTML code from a website to a table? I saw the following script provided in another older thread, but I get an error when trying to run it.

html:
LOAD RecNo() as Rec,
@1:n as Line
(fix, utf8)
;
 
NoConcatenate
html1:
Load
*
Where Line <> '>'
;
Load
RecNo() as Rec,
    subfield(Line,'>') & '>' as Line
Resident html
Order By Rec
;
 
NoConcatenate
html2:
Load
*
Where left(Line, 1) <> '<' and len(trim(Line))>0
;
Load
Rec,
    if(Right(Line,1)='>' and Left(Line, 1) <> '<', '</' & Line, Line) as Line
;
Load
Rec,
subfield(Line,'</') as Line
Resident html1
Order By Rec;
 
drop tables html, html1;
 
Andr_0-1715643252518.png

 

Any solutions to read a web page to table? I note that the docs on the Load advise loading from a webpage is possible?

Andr_1-1715643292993.png

 

Labels (1)
  • SaaS

1 Reply
André
Contributor III
Contributor III
Author

Bump