topic Re: Peek Function in QlikView

Peek Function

nahuel04 — Sat, 16 Nov 2024 20:44:05 GMT

Hello I have a problem with a Peek Function. let me explain me .

I try to load this from management console (I attached a Script and log), but peek function lost the value in a console .

I running it from my qlikview desktop and work properly,

Thanks.

Re: Peek Function

jaibau1993 — Tue, 04 Jun 2019 06:58:09 GMT

Hi!

Maybe AppSheet_tabla is concatenating to AppSheet_Archivos so when you drop AppSheet_Archivos "both" tables are deleted. Try forcing no-concatenation:

AppSheet_tabla:

NoConcatenate Load Distinct

CodigoCC as Codigo_Granja,

NombreGranja,

NombreGranjaAppshet

Resident AppSheet_Archivos;

Regards,

Jaime.

Re: Peek Function

nahuel04 — Tue, 04 Jun 2019 14:00:08 GMT

Hi Jaime .

Thanks to reply ... I tried to noconcatenate AppSheet_tabla: before but it doesn't work, the main problem is when i execute from management console, let granjas =Peek('NombreGranjaAppshet',$(i),'AppSheet_tabla'); doesn't get the value. on other hand when I execute from my qlikview desktop it work properly .

Thanks very much.

Re: Peek Function

jaibau1993 — Tue, 04 Jun 2019 14:34:58 GMT

Hi again!

I've been looking into your log. As you may see there is no data in AppSheet_tabla:

03/06/2019 17:22:17: 3 fields found: Codigo_Granja, NombreGranja, NombreGranjaAppshet, 0 lines fetched

So the problem is not the peek function, the problem is the table. I continued looking at the log and I found that AppSheet_tabla comes from AppSheet_Archivos. AppSheet_Archivos comes from a Resident on ARCHIVOS and has, initially, 13 rows:

03/06/2019 17:22:17: 7 fields found: ARCHIVO_CORTO, EXTENSION, CARPETA, NombreGranjaAppshet, FECHA, ARCHIVO_LARGO, TAMAÑO, 13 lines fetched

BUT then there is a inner join by NombreGranjaAppshet with an excel file named Cod_Granjas.xlsx. My bet is that this inner join is not being done correctly. Check it!

Regards,

Jaime.

Re: Peek Function

nahuel04 — Tue, 04 Jun 2019 17:06:57 GMT

Thanks Jaime,

I attach both logs from my qlikview desktop and management console when i execute from my qlikview desktop, and It is ok .....

but from management console doesn't work.

Re: Peek Function

jaibau1993 — Wed, 05 Jun 2019 06:31:54 GMT

In the last losg you attached there are no "Peek" functions. Script in log 1 is different from script in log 2.

These are the last lines of the second log:

04/06/2019 14:05:33: 0079 AppSheet_tabla:

04/06/2019 14:05:33: 0080 Load

04/06/2019 14:05:33: 0081 Distinct

04/06/2019 14:05:33: 0082 CodigoCC as Codigo_Granja,

04/06/2019 14:05:33: 0083 Nombre_Granjas as Nombre_Granja_Actual

04/06/2019 14:05:33: 0084 Resident Final

04/06/2019 14:05:33: 2 fields found: Codigo_Granja, Nombre_Granja_Actual, 0 lines fetched

04/06/2019 14:05:33: 0085 Drop Table Final

04/06/2019 14:05:33: Execution finished.

No peek after definition of AppSheet_tabla.

I do insist: Problem is not in peek function but I cant help more with the info I got.

Regards,

Jaime.

Re: Peek Function

nahuel04 — Thu, 06 Jun 2019 15:13:14 GMT

Thanks a lot for your time..
I solved it with other script , I don't know what happened , but the
problem was xlsx file .
Thanks ...