Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

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
Anonymous
Not applicable

Hi Zied,

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

zied_ahmed1
Specialist
Specialist
Author

Hi Shiva,

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

Anonymous
Not applicable

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

zied_ahmed1
Specialist
Specialist
Author

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

Anonymous
Not applicable

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
Specialist III
Specialist III

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
Specialist
Specialist
Author

the load statement is an excel file