[Qlik Sense Cloud] Load HTML code from a webpage

[André]

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

FROM [https://www.google.com/index.html]

(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;

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é]

Bump

[tvolkmerwolf]

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!