4 Replies Latest reply on Jul 14, 2016 10:52 AM by Sudheesh Rao

    Finding Unique Values

    Sudheesh Rao

      Hi all,

       

      Not sure if this has been covered anywhere but I am looking for solution to the problem I am facing.

       

      I have a table with Order ID and Product name. I want to compute a value in col C 'True' when the order ID has only Product 'A'.

       

       

      Col ACol bCol C
      Order IDProduct NameTrue/False
      1234AFALSE
      1234BFALSE
      1234AFALSE
      1234DFALSE
      1125ATRUE
      1147BFALSE
      1589ATRUE
      1589ATRUE
      1892ATRUE

       

       

      Please help.


      Regards.

       

      Sudheesh Rao

       

       

      Jonathan Drummey