1 Reply Latest reply on Dec 20, 2016 1:43 PM by Shinichiro Murakami

    Removing values if they are seen with another dimension, set difference

    w asdf

      So here is the scenario

      Picture the table below

      A ,B C

      1,H,J

      2,H,J

      2,L,J

      3,H,J

       

      I want all grouped values of dimensions B and C that have an  A value of 2 or 3 but have no corresponding value where A is 1.

       

      So in this example the only row would be

       

      2,L,J

       

      something like

      select b,c from table

      Minus

      select b,c from table where a =  1