4 Replies Latest reply: Mar 3, 2016 7:19 AM by Avinash R RSS

    How to sort based on 2 string values

    radhika sriramoju

      Hi

       

      I have 2 columns Group and Function , I need to sort Function based on Group values and retrieve the first Function value based on Group values

       

      Group Values

      Agent

      Billing

       

      Functions values

       

      ABC

      BBB

      CCC

      DDD

       

      Association  between Group and Function is as below :

       

      Agent - ABC

      Agent - BBB

      Billing - CCC

      Billing - DDD

       

      I need to get ABC value

       

      Thanks!