Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour,
J'ai la table suivante :
TEMP:
LOAD * inline [
cmd,date,info,ville
ABC,12/02/18,autor,V1
ABC,15/02/18,validation,V1
GHI,05/03/18,validation,V2
CHU,05/03/18,autor,V3
EPO,02/03/18,validation,V4
CHU,06/03/18,validation,v3
];
Pour chaque cmd je souhaiterai avoir l'autor et la validation sur la même ligne comme suit :
ABC,12/02/18,autor,15/02/18,validation,V1
Merci d'avance pour votre aide.
Cordialement
Bonjour,
Ma réponse :
TEMP:
LOAD * inline [
cmd,date,info,ville
ABC,12/02/18,autor,V1
ABC,15/02/18,validation,V1
GHI,05/03/18,validation,V2
CHU,05/03/18,autor,V3
EPO,02/03/18,validation,V4
CHU,06/03/18,validation,v3
];
TABLE1:
NoConcatenate
LOAD cmd, date as DateAutor, ville as VilleAutor
Resident TEMP
Where info = 'autor';
Join
LOAD cmd, date as DateValidation, ville as VilleValidation
Resident TEMP
Where info = 'validation';
drop table TEMP;
Bonjour,
Ma réponse :
TEMP:
LOAD * inline [
cmd,date,info,ville
ABC,12/02/18,autor,V1
ABC,15/02/18,validation,V1
GHI,05/03/18,validation,V2
CHU,05/03/18,autor,V3
EPO,02/03/18,validation,V4
CHU,06/03/18,validation,v3
];
TABLE1:
NoConcatenate
LOAD cmd, date as DateAutor, ville as VilleAutor
Resident TEMP
Where info = 'autor';
Join
LOAD cmd, date as DateValidation, ville as VilleValidation
Resident TEMP
Where info = 'validation';
drop table TEMP;