Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Jordi,
try let nombre_web = peek('Equipo_Web',$(n),'Table_Web');
Regards
Hi Jordi,
try let nombre_web = peek('Equipo_Web',$(n),'Table_Web');
Regards