3 Replies Latest reply: Feb 23, 2011 2:20 AM by samirks27 RSS

    String  equality comparison


      I am using the relation operator '<>' in the following load statement to filter out the records:

      LOAD * FROM ..\Producer\DR_prd_CSV_data.qvd (qvd) WHERE (LOGIN_ID <> 'rozanne' and LOGIN_ID <> 'patric');

      This is not including these two login ids into the result.

      When I using the relation operator '=' to include these login ids into the records , it is not working.

      LOAD * FROM ..\Producer\DR_prd_CSV_data.qvd (qvd) WHERE (LOGIN_ID = 'rozanne' and LOGIN_ID = 'patric');

      How to do the string equality checking in QlikView 9 in above scenario?

      Thanks in advance.