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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79
| TABLE1:
LOAD *,
IF([rep]='positive',[VRP],IF([rep]='negative',[VRN],''))AS [VRECO];
LOAD *,
IF([rep]='positive', [COD RP1], [COD RN1]) AS [n°1 Raison de RECO / non-RECO];
LOAD *,
IF([rep]='positive', [COD RP2], [COD RN2]) AS [n°2 Raison de RECO / non-RECO];
LOAD *,
IF([rep]='positive', [COD RP3], [COD RN3]) AS [n°3 Raison de RECO / non-RECO];
LOAD *,
If ([COD RETOUR2]=2, [VR],'') as [VR1];
LOAD *,
If ([COD RETOUR2]=2, [CODE 4],'') as [OR];
LOAD *,
If ([RD]=2,'oui','non') as [Retour];
LOAD A ,
B ,
C ,
D,
E,
F,
G,
H,
I,
J,
K,
L,
M,
N,
O,
P,
Q,
R,
S,
T,
U,
V,
if (V=1,'positive',if(V=2,'negative', if(V=3,'negative', if (V=4, 'negative')))) as [rep],
W,
X,
Y as [RD],
Z,
AA,
AB,
AC,
AD,
AE as [VRP],
AF as [COD RP1],
AG as [COD RP2],
AH as [COD RP3],
AI as [VRN],
AJ as [COD RN1],
AK as [COD RN2],
AL as [COD RN3],
AM,
AN,
AO as [COD RETOUR2],
AP,
AQ,
AR,
AS,
AT as [VR],
AU,
AV,
AW,
AX as [CODE 4],
AY,
AZ,
BA,
BB
FROM
[C:\Users\jXXXX\Downloads\Entraînement automobile.xlsx]
(ooxml, embedded labels, table is Feuil1); |
Partager