variable its null in script

sorrakis01 — Tue, 07 Oct 2014 18:50:01 GMT

Hi,

I have a variable in a script that serves me for capture several web links, but the problem is that is initialized to NULL every time I, Deputy script

Table_Web:

LOAD ID,

Equipo,

Equipo_Web (nombre del equipo en enlace web)

FROM

EXCEL FIle;

FOR n = 0 TO 30

let nombre_web = peek('Equipo_Web',$(n),Table_Web);

Table_Personas:

LOAD Persona,

[Fe. nac.] as [Fecha Nacimiento Persona]

FROM

[xxxxxxxxxxxxxxxxxxxxxxxxxxxxx$(nombre_web)/9/]

NEXT n;

When n is 0 the first time I catch well but when i is 1 and I did not catch anything and leaves it NULL.

I have seen that if the variable charge in the following table LOAD People, if I work the loop and then if that includes the variable, but not because it does not let me put:

Table_Personas:

LOAD Persona,

[Fe. nac.] as [Fecha Nacimiento Persona],

$(n) as ID_NUM (this is giving me error)

FROM

[xxxxxxxxxxxxxxxxxxxxxxxxxxxxx$(nombre_web)/9/]

You know what could be the problem?

Thanks for your help.

Re: variable its null in script

alex_millan — Wed, 08 Oct 2014 11:43:03 GMT

Hi Jordi,

try let nombre_web = peek('Equipo_Web',$(n),'Table_Web');

Regards

topic Re: variable its null in script in QlikView

variable its null in script

Re: variable its null in script