Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour à tous,
Je récupère des fichiers servant à logguer les status d'un projet, ces fichiers ont le type d'enregistrement suivant:
Meeting Date | Meeting Type | GateWay Type | GateWay Weight | Projet Ref | Projet Name | Roadmap | T-1 | T0 | T1 | T2 | T3 | T4 | T5 | T6 |
07/02/2017 | SteerCo | T3 | 5 | THX-005 | Final Name 1 | 2017RM_042 | 11/07/2016 | 20/09/2016 | 07/02/2017 | |||||
20/09/2016 | SteerCo | T0 | 2 | THX-005 | Reviewed Name 1 | 2017RM_049 | 11/07/2016 | 20/09/2016 | ||||||
11/07/2016 | Advosory Co | T-1 | 1 | THX-005 | Initial Name 1 | NR | 11/07/2016 | |||||||
01/02/2017 | SteerCo | T3 | 5 | THX-005 | Final Name 2 | 2016RM_030 | 04/07/2016 | 20/09/2016 | 01/02/207 | |||||
15/09/2016 | SteerCo | T0 | 2 | THX-005 | Reviewed Name 2 | 2016RM_030 | 04/07/2016 | 20/09/2016 | ||||||
04/07/2016 | Advosory Co | T-1 | 1 | THX-005 | Initial Name 2 | NR | 04/07/2016 |
Je ne voudrais charger que les enregistrer ayant la valeur maximum de la colonne "Gateway Weight"
donc ces derniers :
Meeting Date | Meeting Type | GateWay Type | GateWay Weight | Projet Ref | Projet Name | Roadmap | T-1 | T0 | T1 | T2 | T3 | T4 | T5 | T6 |
07/02/2017 | SteerCo | T3 | 5 | THX-005 | Final Name 1 | 2017RM_042 | 11/07/2016 | 20/09/2016 | 07/02/2017 | |||||
01/02/2017 | SteerCo | T3 | 5 | THX-005 | Final Name 2 | 2016RM_030 | 04/07/2016 | 20/09/2016 | 01/02/207 |
J'ai cherché du côté de group by et firstvalue mais je cale.
Merci d'avance pour votre aide.
Finally I managed to do that with firstsortedvalue on each field where i need to get the last value.
firstsortedvalue(ApplyMap('Tbl_Comite',[Meeting Type]),-[GateWay Weight]) As [Meeting Type],
May be use Front End in Straight Table
Max([GateWay Wight])
J'aii fait une erreur il y a 2 références projets différentes, le but étant de sortir les enregistrements avec le dernier statut du projet donc on peut prendre que les 3 derniers lignes du premiers tableau portent une réf de projet du type THX-006
Hi Anil,
In fact I tried, but I don't know how to use that max in the loading script
I load all the record in a temp table then I tried something like :
FinalTable:
NoConcatenate LOAD
[Meeting Type],
[Meeting Date],
[GateWay Type],
Max([GateWay Weight]),
......
RESIDENT TempTable
GROUP BY [Meeting Type], [Meeting Date], [GateWay Type],... ;
Finally I managed to do that with firstsortedvalue on each field where i need to get the last value.
firstsortedvalue(ApplyMap('Tbl_Comite',[Meeting Type]),-[GateWay Weight]) As [Meeting Type],