topic Call subroutine with table name as argument in QlikView

Call subroutine with table name as argument

cristian_av — Thu, 24 Jul 2014 14:40:47 GMT

I'm getting the following error: "Script line error" when I call a subroutine. I'm just trying to learn how to use procedures..

I've tryed with many ways to call the subroutine, but i always get the same error.

Can anybody please help me?

Thanks!

-------------------------------------------------

[Hoja1]:

LOAD CAS_TRANSIT_ID, CARD_NUMBER, ESTADO, RUT, TERMINAL, KIOSCO, SERVICIO, CTTO, RUT_EMPRESA, CENTRO_COSTO, RAZON_SOCIAL, GERENCIA, TRANSIT_DATE, INSERT_DATE FROM [..\..\ConsumosExcel\ConsumoExcel2014-06.xlsm] (ooxml, embedded labels, table is Hoja1);

SET vVar ='Hola';

CALL testTransformarDatos(Hoja1);

CALL testTransformarDatos('Hoja1');

CALL testTransformarDatos($(vVar));

SUB testTransformarDatos(vTablaOrigen)

DROP TABLE $(vTablaOrigen);

END SUB

Re: Call subroutine with table name as argument

maxgro — Thu, 24 Jul 2014 14:45:27 GMT

[Hojal]:

LOAD * inline [

field

];

SUB testTransformarDatos(vTablaOrigen)

DROP TABLE $(vTablaOrigen);

END SUB

SET vVar ='Hojal';

//CALL testTransformarDatos(Hoja1);

//CALL testTransformarDatos('Hoja1');

CALL testTransformarDatos('$(vVar)');

Re: Call subroutine with table name as argument

cristian_av — Thu, 24 Jul 2014 15:53:17 GMT

Thank you!

I didn't know that i have to put the procedure on the first tab..