0 Replies Latest reply: Jan 17, 2018 7:30 AM by nagarjuna reddy RSS

    How to get no of meeting Based on Client name and unique Meeting Id

    nagarjuna reddy

      Hii..

       

      my source like below ..

          

      Meeting IdEvent DateEvent TypeMeeting Type CodeClient NameProduct Line
      161967P1/24/2017ConferenceDINNERAnbang Asset Mgmt (Hong Kong) Co LtdEconomics
      1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                  
      1305486H1/12/2017Analyst Marketing DayGRPAXA Inv Mgrs - EuropeEuropean Shares            
      Meeting IdEvent DateEvent TypeMeeting Type CodeClient NameProduct Line
      161967P1/24/2017ConferenceDINNERAnbang Asset Mgmt (Hong Kong) Co LtdEconomics
      1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                  
      1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                  
      1307755H2/15/2017Field TripGRPAmansa CapitalAsian Shares
      1320065H3/16/2017Analyst Marketing Day1X1T Rowe Price - Investment AdvisorLatin American Shares      
      1310503H3/2/2017Non Deal ManagementGRPBank J Safra SarasinPanEuro Shares              
      1320452H3/9/2017Field TripGRPLombard Odier Darier Hentsch & Cie - Private BankPanEuro Shares              
      1320452H3/9/2017Field TripGRPBDK Capital SASPanEuro Shares              

       

            How to get No of meetings and Rank based on the attendee the meeting id in meeting id have a duplicate id

       

      Thanks