Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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