3 Replies Latest reply: Jul 29, 2015 8:34 AM by Sreehari Satheesan RSS

    where condition with 'and','or' and not equal to combination working ?

      Hi All,

       

      Please let me know how not equal works in where condition works with and or operators.

       

      Like I have two columns Region with entries AMS and Business Unit with entries 'PPS Commercial' and 'PPS Consumer'.

      I don't need to load the data when Region = 'AMS' and Business Unit ='PPS Consumer'  & Region = 'APJ' and Business Unit ='PPS Consumer' .

      I have written code like below

       

       

      Load Region,

      Business Unit

       

      from

      Sample.xlsx

      where (   (Region<>'AMS' or Business Unit <>'PPS Consumer' )  and (Region<>'APJ' or Business Unit <>'PPS Consumer' ) );

       

      It is working fine but not able to understand how it working correctly . Because as per my understanding it has to be "and "in the place of "or "and vice versa in the above expression.

       

       

      Thanks in Advance ,

      Sreehari Satheesan