Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

holguinmora
New Contributor III

Create a connection to a File to count lines / Pages

Hi to all!!! 

I´m trying to connect with qlik sense Desktop or Business Cloud  to a .HTM file store in Dropbox account. The purpose of this connection is to count the number of pages from file that varies form day to day.

With this count I will be able to create a variable and get all the data.

Any ideas?

Script to get the file and manually adjust the number of pages:

LOAD*

FROM [lib://Dropbox - xxxxxxxxxx/Job REPORTE DE VENTAS, Step 1.htm]
(html, codepage is 708, embedded labels, table is @1);

I also tried with: 

ODBC CONNECT with no results, it tells me that the only option in script is using LIB

As always any help will be more than apreciate