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

variable its null in 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 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.

1 Solution

Accepted Solutions
alex_millan
Creator III
Creator III

Hi Jordi,

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

Regards

View solution in original post

1 Reply
alex_millan
Creator III
Creator III

Hi Jordi,

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

Regards