Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
holguinmora
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

Labels (5)
0 Replies