Peek Function

[nahuel04]

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.

[jaibau1993]

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.

[nahuel04]

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.

[jaibau1993]

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.

[nahuel04]

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.

[jaibau1993 · Accepted solution]

Hi

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.

[nahuel04]

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 ...