2 Replies Latest reply: Dec 12, 2011 12:42 AM by Sachin Sahu RSS

    Apply sql query operators

      Hello,

       

      How to apply sql query in qlikview script?

       

      LOAD *

      FROM data.txt

      (txt, codepage is 1252, embedded labels, delimiter is '|', msq);

       

      I want to apply:

      WHERE country not like A* ?

       

      WHERE postcode <> '1100' AND postcode <> '2200'

      How to combine into WHERE postcode <> '1100 2200' ?

       

      Thanks in advance.

        • Apply sql query operators
          Sridhar Ethiraj

          Hi,

           

          You can use Not WildMatch() to do this.

           

          Your code should like below.

           

          LOAD *

          FROM data.txt

          (txt, codepage is 1252, embedded labels, delimiter is '|', msq)

          Where Not WildMatch(postcode,'1100','2200') and Not WildMatch(country ,'A*');

           

          Hope this helps you.

           

          -Sridhar

          • Apply sql query operators
            Sachin Sahu

            Hi

             

            we Can apply SQL Query in

            SQL select statement

            Which is used to fetech data from Database

             

            and regarding Where clause

             

            Where Not WildMatch(postcode,'1100','2200') and Not WildMatch(country ,'A*');