Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

zied_ahmed1
Contributor III

Problem in script

Hello,I have a script work :

tmp:

load *;

SELECT CodAttivita,

  ACTIVITE,

  sens,

  FilialeInserimento,

  FilOrigine,

  PaysOrigine,

  FilialeDestino,

  CodLinea as Code_Ligne,

  Dossier,

  ViaggioNave,

    "Statut_Flotte",

  cast("date_dossier" as date) as  date_dossier,

  DateEmbarquement,

  DateDebarquement,

  VideCpltGrpg,

  Plaque,

  TypeMateriel,

    DesCompagnia,

  Remorque,

    Parc,

  ViaggioLinea,

    carrier

FROM

where (ACTIVITE='RORO' and ViaggioNave>0);

load *;

SELECT CodAttivita,

  ACTIVITE,

  sens,

  FilialeInserimento,

  FilOrigine,

  PaysOrigine,

  FilialeDestino,

  CodLinea as Code_Ligne,

    "Statut_Flotte",

  Dossier,

  ViaggioNave,

  cast("date_dossier" as date) as  date_dossier,

  DateEmbarquement,

  DateDebarquement,

  VideCpltGrpg,

  Plaque,

  TypeMateriel,

     DesCompagnia,

  Remorque,

    Parc,

  ViaggioLinea,

    carrier

FROM

where (ACTIVITE<>'RORO');

left join(tmp)

LOAD

    Pays,

    Langitude,

    Latitude,

    Code_Ligne

FROM

[COM_BI_Dossier_Cat]:

LOAD

   autonumber( date(date_dossier, 'DD/MM/YYYY'),'%Date ID')  as [%Date ID]

   ,CodAttivita as Code_Activite,

  ACTIVITE as Designation_Activite,

  sens as Sens,

  FilialeInserimento as Filiale_Creation_Dossier,

  FilOrigine as [Filiale Origine],

  PaysOrigine as [Pays Fililale Origine],

  FilialeDestino as [Filiale Destination],

  Code_Ligne as Code_Ligne,

  Dossier as Num_Dossier,

  ViaggioNave as Num_Voyage,

  date(date_dossier,'DD/MM/YYYY') as Date_Dossier,

  DateEmbarquement as Date_Embarquement,

  DateDebarquement as Date_Debarquement,

     "Statut_Flotte" as "Statut Flotte",

  VideCpltGrpg as Groupe_Complet_Vide,

  Plaque,

     Parc,

  TypeMateriel as Type_Materiel,

      DesCompagnia as Compagnie,

  Remorque as Remorque_Parc_HorsParc,

  ViaggioLinea as Voyage_Ligne,

   // ViaggioNave as Voyage_bateau,

  carrier as Code_Carrier

    ,Pays,

    geomakepoint(Latitude,Langitude) as PAYS2

resident tmp  ;

drop table tmp;

NoConcatenate

final_tmp:

load*,'Vide' as Charge_Vide;

load * Resident [COM_BI_Dossier_Cat] where (upper(Groupe_Complet_Vide)='V');

load*,'Chargé' as Charge_Vide;

load * Resident [COM_BI_Dossier_Cat] where (upper(Groupe_Complet_Vide)<>'V');

drop table final_tmp;

but when i add this block of script the values becomes wrong :

Fact_Final:

Load  Date_Embarquement,   

    Plaque,

    if( Nombre_Carrier>1, 1, 0) as Flag_Doublon;

LOAD  

    Date_Embarquement,   

    Plaque,  

  count(Code_Carrier) as Nombre_Carrier

Resident final_tmp

Where Code_Ligne = 'MAR' 

Group by Date_Embarquement,Plaque

;

join(Fact_Final)

LOAD  *

Resident final_tmp

Where Code_Ligne = 'MAR'  ;

Concatenate

load * resident final_tmp where Code_Carrier <>'MAR';

What i can do to resolve this problem ? Thanks

7 Replies
laddu_927
Valued Contributor

Re: Problem in script

Hi Zied,

Are you getting any error or getting the output incorrect??

zied_ahmed1
Contributor III

Re: Problem in script

Hi Shiva,

No,i don't get errors just the values are not correct

laddu_927
Valued Contributor

Re: Problem in script

Can you share the application or atleast some screenshots which may help us to find the error.

zied_ahmed1
Contributor III

Re: Problem in script

you need some screenshots of table where the values are wrong ?

laddu_927
Valued Contributor

Re: Problem in script

Where are you adding the below block??? As the

Fact_Final:

Load  Date_Embarquement, 

    Plaque,

    if( Nombre_Carrier>1, 1, 0) as Flag_Doublon;

LOAD 

    Date_Embarquement, 

    Plaque, 

  count(Code_Carrier) as Nombre_Carrier

Resident final_tmp

Where Code_Ligne = 'MAR'

Group by Date_Embarquement,Plaque

;

join(Fact_Final)

LOAD  *

Resident final_tmp

Where Code_Ligne = 'MAR'  ;

Concatenate

load * resident final_tmp where Code_Carrier <>'MAR';


as you are dropping the table

drop table final_tmp.


And what is  the source for this load statement??

LOAD

    Pays,

    Langitude,

    Latitude,

    Code_Ligne

FROM


Can you check once.


rahulpawarb
Valued Contributor II

Re: Problem in script

Hello Zied,

Trust that you are doing well!

Could you please share the application with sample data? This will help us to understand the issue and provide your expected response.

Regards!

Rahul

zied_ahmed1
Contributor III

Re: Problem in script

the load statement is an excel file