Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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

2 Replies
André
Contributor III
Contributor III
Author

Bump

tvolkmerwolf
Partner - Creator
Partner - Creator

Hi André,

just stumbled across the same question and found this one:

Solved: How to connect with web file (SaaS and Client Mana... - Qlik Community - 1858684

See the remark from DLopeze where he states that he/she found another way.


Hope this helps!