Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Create and Insert a Variable

Hi to all

On the next lines a variable that I´m trying to create and insert a variable to get all the tables in a HTML file. 

The value on field "Hojas" is 5 that equals the number of tables in file:  

FROM [lib://Dropbox - alejandro@inflexion.com.co/PruebasHojas/Job REPORTE DE VENTAS, Step 1.htm]

Script:

LOAD
Hojas
FROM [lib://NumeroHojas]
(html, codepage is 28591, embedded labels, table is @1);

let vprueba= Hojas;
drop Table;

For VHojas = 1 to $vprueba;

LOAD
*
FROM [lib://Dropbox - alejandro@inflexion.com.co/PruebasHojas/Job REPORTE DE VENTAS, Step 1.htm]
(html, codepage is 708, embedded labels, table is [$(VHojas)$]);

And I get the next error:

Captura de Pantalla 2019-08-18 a la(s) 9.51.42 a. m..png

 

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Try to define your variable like this:

let vprueba= peek('Hojas',-1,'YourTable');

It will fetch the value of Hojas on the last row in a table called YourTable. Adjust the table name to fit your data.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Highlighted
Partner
Partner

Try to define your variable like this:

let vprueba= peek('Hojas',-1,'YourTable');

It will fetch the value of Hojas on the last row in a table called YourTable. Adjust the table name to fit your data.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Contributor III
Contributor III

It worked perfectly!!!

Thank You very much!!