error in variable script

sorrakis01 — Tue, 07 Oct 2014 18:53:30 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, except the first time that the value its right.

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

********************************* $(nombre_web)/9/ (html link)

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

******************************** $(nombre_web)/9/] (html link)

You know what could be the problem?

Thanks for your help.

Re: error in variable script

sorrakis01 — Wed, 08 Oct 2014 10:55:20 GMT

Hi,

Anyone can helps me?

Thanks

Re: error in variable script

DavidFoster1 — Wed, 08 Oct 2014 10:59:42 GMT

In the peek statement the table name needs to be single quotes.

Re: error in variable script

sorrakis01 — Wed, 08 Oct 2014 11:04:09 GMT

Thanks David!!!!!

1 milion of thanks.

Regards

Re: error in variable script

DavidFoster1 — Wed, 08 Oct 2014 11:06:16 GMT

no problem.

topic Re: error in variable script in QlikView

error in variable script

Re: error in variable script

Re: error in variable script

Re: error in variable script

Re: error in variable script