4 Replies Latest reply: May 19, 2014 3:24 AM by Bhaskar Sharma RSS

    Get one string from multiple options

    Bhaskar Sharma

      Hi,

       

      I have a scenario where one ID may have multiple descriptions. I need to create a straight table to aggregate the Amount based on the ID's; however, only one description should appear in the straight table. I am OK to have any of the multiple descriptions, with no preference as such.

       

      Please look at the attached image for more details.

       

      Thanks in advance for your help.

       

      Regards,

      Bhaskar