topic Problema en Script in App Development

Problema en Script

Raskolnikov — Tue, 31 Dec 2019 13:28:53 GMT

Hola

Estaba probando incluir una evaluación que se guarde en un nuevo campo en el script sin embargo me da un error.

LOAD

..................

Cd_TipoDestino,
if(min(Cd_TipoDestino)=0,'No Aplica','Aprobada') as Asdfg,

FROM ..................

He descubierto que el error me lo tira al incluir el MIN. Pero no se por que.

Saludos

Re: Problema en Script

Kushal_Chawda — Tue, 31 Dec 2019 13:31:51 GMT

If you are using other columns in load script then you should apply group by statement as you are using aggregation function within script.

Cd_TipoDestino,
load Field1,Field2,if(min(Cd_TipoDestino)=0,'No Aplica','Aprobada') as Asdfg

FROM ..................

Group by Field1,Field2;

Re: Problema en Script

Raskolnikov — Tue, 31 Dec 2019 13:34:36 GMT

[Desembarque Artesanal Cuota]:
LOAD
NumeroDeclaracion,
TipoIngreso,
Nr_RutArma,
Cd_Nave as RPA_Emb,
Cd_PtoZArpe,
Fc_Zarpe,
Cd_PtoLlegada,
Fc_Llegada,
Cd_Estado as EstadoDA,
Ac_Nave,
//Cd_Usuario,
//Nm_UsuarioSav,
Fc_Recepcion,
idAvisoRecaladaCert as Nr_FolioAvisoRecalada,
Nr_Item,
Cd_Especie as Especie_DA,
Cd_Arte,
Cd_Regimen,
Cd_Zona,
Cd_TipoDestino,
if(min(Cd_TipoDestino=0),'No Aplica','Aprobada') as Asdfg,
Cd_Destino,
Nr_Toneladas,
Ac_Especie,
Nm_Evicerado,
Nr_ClaveResol,
Nr_RpaBuzo,
vizado
FROM [lib://QVDFlotaArtesanal (sernap_qlikview)/DESEMBARQUE_DA_CUOTA.qvd]
(qvd) where idAvisoRecaladaCert>0;

Re: Problema en Script

Kushal_Chawda — Tue, 31 Dec 2019 13:41:35 GMT

try this [Desembarque Artesanal Cuota]: LOAD NumeroDeclaracion, TipoIngreso, Nr_RutArma, Cd_Nave as RPA_Emb, Cd_PtoZArpe, Fc_Zarpe, Cd_PtoLlegada, Fc_Llegada, Cd_Estado as EstadoDA, Ac_Nave, //Cd_Usuario, //Nm_UsuarioSav, Fc_Recepcion, idAvisoRecaladaCert as Nr_FolioAvisoRecalada, Nr_Item, Cd_Especie as Especie_DA, Cd_Arte, Cd_Regimen, Cd_Zona, Cd_TipoDestino, if(min(Cd_TipoDestino=0),'No Aplica','Aprobada') as Asdfg, Cd_Destino, Nr_Toneladas, Ac_Especie, Nm_Evicerado, Nr_ClaveResol, Nr_RpaBuzo, vizado FROM [lib://QVDFlotaArtesanal (sernap_qlikview)/DESEMBARQUE_DA_CUOTA.qvd] (qvd) where idAvisoRecaladaCert>0 group by NumeroDeclaracion, TipoIngreso, Nr_RutArma, Cd_Nave, Cd_PtoZArpe, Fc_Zarpe, Cd_PtoLlegada, Fc_Llegada, Cd_Estado, Ac_Nave, Fc_Recepcion, idAvisoRecaladaCert, Nr_Item, Cd_Especie, Cd_Arte, Cd_Regimen, Cd_Zona, Cd_Destino, Nr_Toneladas, Ac_Especie, Nm_Evicerado, Nr_ClaveResol, Nr_RpaBuzo, vizado;

Re: Problema en Script

Raskolnikov — Tue, 31 Dec 2019 14:09:35 GMT

red lines 😞

Re: Problema en Script

Kushal_Chawda — Tue, 31 Dec 2019 14:13:34 GMT

can you send the screenshot of the script?

Re: Problema en Script

Raskolnikov — Tue, 31 Dec 2019 14:17:40 GMT

Re: Problema en Script

Kushal_Chawda — Tue, 31 Dec 2019 14:22:27 GMT

Please add group by part also as suggested