2 Replies Latest reply: Apr 21, 2010 12:09 PM by Tom Mathew RSS

    using "like" in the script

      I'm trying to use the "like" operator in my load script to limit what date is fed into my QlikView application...For example...

       


      LOAD
      Id as PersonId,
      Name as PersonName,
      Address as PersonAddress
      FROM DataFile.csv
      WHERE Address like 'Street';


      That is, I only want to load data that has the string "Street" somewhere in the Address field. If that string does not exist in the Address field, do not load that data row. I tried using the "like" operator in the script with no luck. Any ideas?