2 Replies Latest reply on Oct 31, 2018 8:44 AM by Gagan Thapar

    How to use exists and not exists in tableau

    Gagan Thapar

      I am struggling with exists and not exists in tableau the way I can do that in DB query. I posted the sample data here.

       

      I want to find out which and how many locations have ABC and ABCD.

      Which and How many locations have ABCD12345678, ABCD1 and not ABC.

       

      I could have multiple combinations like that. Can anyone help me with this requirement?

       

        

      HNS_LOCATION_IDHNS_PRODUCT_CODE
      1000682ABC
      1000682ABCD
      1000682ABCD1
      1000682ABCD12
      1000682ABCD123
      1000682ABCD1234
      1000682ABCD12345
      1000682ABCD123456
      1000682ABCD1234567
      1000683ABCD
      1000683ABCD1234567
      1000683ABCD12
      1000683ABCD1
      1000683ABCD1234
      1000683ABCD123456
      1000683ABCD12345
      1000683ABCD123
      1000683ABC
      1000685ABCD
      1000685ABCD12
      1000685ABCD1234567
      1000685ABCD1
      1000685ABCD12345
      1000685ABCD123
      1000685ABCD1234
      1000685ABCD123456
      1000685ABCD12345678