Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sorrakis01
Specialist
Specialist

error in variable script

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.

1 Solution

Accepted Solutions
DavidFoster1
Specialist
Specialist

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

View solution in original post

4 Replies
sorrakis01
Specialist
Specialist
Author

Hi,

Anyone can helps me?

Thanks

DavidFoster1
Specialist
Specialist

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

sorrakis01
Specialist
Specialist
Author

Thanks David!!!!!

1 milion of thanks.

Regards

DavidFoster1
Specialist
Specialist

no problem.