1 2 3 4 5 6 7 8 9 10 11 12 13 14
| Comptage:
Load * inline [DateOp,Client,Commande,Article,PxUnitaire,Quantité,PxLigne
27/02/2015,52,C184ZI,3519874,2,10,20
27/02/2015,52,C184ZI,6321584,5,20,100
27/02/2015,33,C185TZ,5698745,15,15,225
27/02/2015,32,C187XT,6321584,5,10,50
03/03/2015,52,C233XS,3519874,2,20,40
11/03/2015,52,C365SA,5698745,15,10,150
11/03/2015,52,C365SA,6321584,5,5,25
11/03/2015,33,C666DS,3519874,2,10,20
11/03/2015,32,C777SS,6321584,5,20,100];
TableMax:
load Date(max(DateOp)) as DateMaxi resident Comptage; |
Partager