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
| LOAD
year(Date) AS Année,
month(Date) AS Mois,
*
;
LOAD * INLINE [
Date, Valeur
01/01/2013, 20130101
01/02/2013, 20130201
01/03/2013, 20130301
01/04/2013, 20130401
01/05/2013, 20130501
02/05/2013, 20130502
29/05/2013, 20130529
30/05/2013, 20130530
01/06/2013, 20130601
01/07/2013, 20130701
01/08/2013, 20130801
01/09/2013, 20130901
01/10/2014, 20141001
01/11/2014, 20141101
01/12/2014, 20141201
01/01/2014, 20140101
01/02/2014, 20140201
01/03/2014, 20140301
01/04/2014, 20140401
01/05/2014, 20140501
02/05/2014, 20140502
29/05/2014, 20140529
30/05/2014, 20140530
01/06/2014, 20140601
01/07/2014, 20140701
]; |
Partager