Problema en Script

[Raskolnikov]

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

[Kushal_Chawda]

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;

[Raskolnikov]

[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;

[Kushal_Chawda]

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;

[Raskolnikov]

red lines 😞

[Kushal_Chawda]

can you send the screenshot of the script?

[Raskolnikov]

[Kushal_Chawda]

Please add group by part also as suggested