1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| 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
];
data:
NOCONCATENATE LOAD
DISTINCT
cmd, // servira de clé
date AS autor_date,
ville AS autor_ville,
info AS autor // je ne vois pas l'utilité de ce champ
RESIDENT TEMP
WHERE info = 'autor';
JOIN (data)
LOAD
DISTINCT
cmd, // clé
date AS validation_date,
ville AS validation_ville,
info AS validation // je ne vois pas l'utilité de ce champ
RESIDENT TEMP
WHERE info = 'validation'; |
Partager