topic Re: Problem in script in Management & Governance

Problem in script

zied_ahmed1 — Tue, 28 Mar 2017 15:34:54 GMT

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

Re: Problem in script

Anonymous — Tue, 28 Mar 2017 15:50:11 GMT

Hi Zied,

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

Re: Problem in script

zied_ahmed1 — Tue, 28 Mar 2017 15:56:01 GMT

Hi Shiva,

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

Re: Problem in script

Anonymous — Tue, 28 Mar 2017 15:57:59 GMT

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

Re: Problem in script

zied_ahmed1 — Tue, 28 Mar 2017 16:20:30 GMT

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

Re: Problem in script

Anonymous — Wed, 29 Mar 2017 05:39:12 GMT

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.

Re: Problem in script

rahulpawarb — Wed, 29 Mar 2017 07:38:42 GMT

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

Re: Problem in script

zied_ahmed1 — Wed, 29 Mar 2017 08:00:39 GMT

the load statement is an excel file