topic Pass value with variable to subroutine in QlikView

Pass value with variable to subroutine

cristian_av — Fri, 25 Jul 2014 14:39:02 GMT

I'm Having some troubles with passing values to a subroutine.

This works:

	[ConsumosExcel]:
	LOAD * FROM ..\..\Datos\QVDs\Originales\ConsumosExcel.qvd (qvd);

CALL TransformarDatosEBI('ConsumosExcel','Consumos_EBI_Original');

But when i pass a variables, it's not working. It says "table not found". What I'm doing wrong??

Thank you!!!

	[ConsumosExcel]:
	LOAD * FROM ..\..\Datos\QVDs\Originales\ConsumosExcel.qvd (qvd);

END IF

SET vTablaOrigen1='ConsumosExcel';

SET vTablaDestino='Consumos_EBI_Original';

CALL TransformarDatosEBI($(vTablaOrigen1),'Consumos_EBI_Original');

richard_pearce6 — Fri, 25 Jul 2014 14:42:35 GMT

If you put ' ' around your dollar expansion in the call statement that should resolve it..

CALL TransformarDatosEBI('$(vTablaOrigen1)','Consumos_EBI_Original');

maxgro — Fri, 25 Jul 2014 14:44:47 GMT

maybe with ' '

CALL TransformarDatosEBI('$(vTablaOrigen1)','Consumos_EBI_Original');

richard_pearce6 — Fri, 25 Jul 2014 14:47:20 GMT

Great minds think a like Massimo !!