1 Reply Latest reply on Apr 10, 2012 7:49 AM by Mark Holtz

    Filter Rows based on Conditions on Multiple Columns

    sinadashtipour

      Hi All,

       

      As the title reads, I simply would like to filter my rows based on specific values on the different columns, for example see table below:

       

       

      IDCol ACol BCol CCol D
      1null    0-0-0   null      2001-12-01
      2null      0-0-0   1998-11-07   Null
      30-0-0    0-0-0   null      2004-11-05
      4null      2004-05-02   0-0-0   0-0-0
      5null      null     0-0-0    null
      6null      null      null   2002-05-08
      70-0-0    null     0-0-0    0-0-0
      82000-10-08   null     0-0-0   2010-12-05
      92003-04-15 null    0-0-0   2007-02-06
      100-0-0  0-0-0   null    2005-01-12

       

      I need to filter to only show rows where Cold D has a date (i.e. NOT null or 0-0-0) AND Col A, Col B,Col C are null OR 0-0-0.

       

      So table above should filter to only rows: 1,3,6,10

       

      Is this possible?

       

      Thanks