Problem QVD

zied_ahmed1 — Sat, 22 Apr 2017 16:28:23 GMT

Hello,

I have this code and i want to use QVD and concatenate data :

SET vQvdPath=C:\Users\administrateur.VECTORYS\Desktop\Zied\qvdtest\New;

Flotte:

LOAD Plate as Plaque_flotte,

Today() as date_flotte,

TrailerType as Materiel_flotte,

ParkName as Parc_flotte,

SATUT as stat_flotte;

//[CG_FLOTTE_Suivi_Echeances]:

SELECT Plate,

TrailerType,

ParkName,

SATUT

FROM

NoConcatenate

Plaque_all:

load Distinct Plaque,

'1' as statut_inactif,

Type_Materiel as Materiel_flotte,

Today() as date_flotte

resident Fact_Final Where NOT Exists(Plaque_flotte,Plaque) and Type_Materiel<>'DiversMateriel';

Concatenate

Flotte1:

Load

Plaque_flotte ,

Materiel_flotte,

date_flotte,

if(stat_flotte='ACTIF',1,0) as statut_actif,

if(stat_flotte='INACTIF',1,0) as statut_endom,

if(stat_flotte='BLOQUE',1,0) as statut_bloque

Resident Flotte;

drop table Flotte;

NoConcatenate

Flotte2:

load

//stat_flotte,

Plaque,

date_flotte,

Materiel_flotte,

Plaque_flotte as Plaque_flotte,

sum(statut_endom) as statut_endom,

// statut_active,

sum(statut_actif) as statut_actif,

sum(statut_inactif) as statut_inactif,

//ici

sum(statut_bloque) as statut_bloque,

(sum(statut_actif)/day(date_flotte)) as Taux

resident Plaque_all

Group by date_flotte,Materiel_flotte,Plaque_flotte,Plaque

;

drop table Plaque_all;

NoConcatenate

Flotte3:

load

Plaque,

statut_inactif,

statut_bloque,

statut_endom,

date_flotte,

Plaque_flotte as Plaque_flotte,

Materiel_flotte,

if (statut_actif>statut_bloque and statut_actif>statut_inactif,1,

(if(statut_bloque>statut_actif and statut_bloque>statut_inactif,2,

(IF(statut_inactif>statut_actif and statut_inactif>statut_bloque,3))))) as Statut_cond,

Taux ,

statut_actif

Resident Flotte2

;

drop table Flotte2;

NoConcatenate

Flotte4:

load

Plaque,

statut_actif,

date_flotte,

statut_inactif,

statut_bloque,

statut_endom,

//Statut_sup,

Plaque_flotte as Plaque_flotte,

Materiel_flotte,

Taux,

if (Statut_cond=1,'Actif',

(if (Statut_cond=2,'Bloquée',

(IF(Statut_cond=3,'Inactif'))))) as Statut_sup

Resident Flotte3;

drop table Flotte3;

//pour SR sans traversée

NoConcatenate

FlotteFinal:

LOAD Plaque,

date_flotte,

Plaque_flotte as Plaque_flotte,

Materiel_flotte FROM (qvd) ;//source des QVDs historisés

Concatenate:

LOAD

* WHERE "date_flotte"= Today();

load

//Plaque,

date_flotte,

Plaque_flotte as Plaque_flotte,

Materiel_flotte,

Taux,

'ON' as STATUT,

count(Statut_sup) as nbr

resident Flotte4

where Statut_sup='Actif'

group by

date_flotte,

Taux,

//[%Date ID],

Plaque_flotte,

Materiel_flotte;

Concatenate

load

Plaque,

date_flotte,

Plaque_flotte as Plaque_flotte,

Materiel_flotte,

'OFF' as STATUT,

count(Statut_sup) as nbr

resident Flotte4

where Statut_sup='Inactif'

group by date_flotte,

Plaque_flotte,

Materiel_flotte,Plaque;

Concatenate

load

date_flotte,

Plaque_flotte as Plaque_flotte,

Materiel_flotte,

'Bloquée' as STATUT,

count(Statut_sup) as nbr

resident Flotte4

where Statut_sup='Bloquée'

group by date_flotte,

Plaque_flotte,

Materiel_flotte;

drop table Flotte4;

Concatenate

Load*

resident Fact_Final ;

drop table Fact_Final;

STORE [FlotteFinal] into [$(vQvdPath)\QVD_final.qvd.qvd](qvd);

I would like to stoke data of the last table but the problem i have synthetic keys after the concatenate

Regards

Re: Problem QVD

zied_ahmed1 — Sat, 22 Apr 2017 16:29:58 GMT

rahulpawarb‌

Re: Problem QVD

zied_ahmed1 — Sun, 23 Apr 2017 09:55:36 GMT

jagan‌

Re: Problem QVD

rahulpawarb — Mon, 24 Apr 2017 04:18:27 GMT

Hello Zied,

As per the given script Table FlotteFinal will the single table present in the data model. Could you please provide the data model screenshot or complete script? This will help us to identify the issue and provide you expected results.

Regards!

Rahul

Re: Problem QVD

zied_ahmed1 — Mon, 24 Apr 2017 08:04:25 GMT

Hello Rahul,

this is the modele and this is the flotte_finale that i want store it every day

Re: Problem QVD

rahulpawarb — Mon, 24 Apr 2017 08:54:04 GMT

I could not see any synthetic key in given screenshot. What exact problem you are facing while pushing the result to QVD.

Regards!

Rahul

Re: Problem QVD

zied_ahmed1 — Mon, 24 Apr 2017 09:28:40 GMT

yes because i reload without the code of concatenation,

i find my solution i write Concatenate: and i need just Concatenate a very small error thank you

topic Re: Problem QVD in Management & Governance

Problem QVD

Re: Problem QVD

Re: Problem QVD

Re: Problem QVD

Re: Problem QVD

Re: Problem QVD

Re: Problem QVD