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, 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.
In the peek statement the table name needs to be single quotes.
Hi,
Anyone can helps me?
Thanks
In the peek statement the table name needs to be single quotes.
Thanks David!!!!!
1 milion of thanks.
Regards
no problem.