I would like to use Preceding Load with this code :
LOAD
* WHERE "date"= Today() ;
load
date,
car as car,
mat ,
Tax,
'ON' as STATUT,
count(Statut_sup) as nbr
resident table1
where Statut_sup='Actif'
group by
date_flotte,
Taux,
//[%Date ID],
car ,
mat;
Concatenate
load
Pla,
date,
car as car,
mat,
'OFF' as STATUT,
count(Statut_sup) as nbr
resident table1
where Statut_sup='Inactif'
group by date,
car,
mat,
Pla;
Concatenate
load
date,
car as car,
mat,
'Bloquée' as STATUT,
count(Statut_sup) as nbr
resident table1
where Statut_sup='Bloquée'
group by date,
car,
mat;
drop table table1;
STORE [FlotteFinal] into [$(vQvdPath)\QVD_final.qvd](qvd);
Concatenate
Load*
resident Fact ;
drop table Fact;
