This file has 4 sheets, when the condition is met VAsterisco goes = 1 and should stop.
When I run this code:
let vPagina = 1; // let vFinPagina='Inicio'; Do While VAsterisco <> 1;
Ventas:
LOAD Período, if(Período='*',1) as Asterisco, Ingresos
FROM [lib://Dropbox - alejandro@inflexion.com.co (qlikcloud_qlikid_aholguininflex)/PruebasHojas/Job REPORTE DE VENTAS, Step 1.htm] (html, codepage is 708, embedded labels, table is @$(vPagina));
VAsterisco= Asterisco;
vPagina = vPagina+1;
loop
I get this error: Table '@5' not found... Any ideas?