Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

0 Replies