Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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