2 Replies Latest reply: Sep 15, 2010 6:35 PM by Philip Duplisey RSS

    Where Clause in QVD load

    Philip Duplisey

      I have an app loading incremental data daily. In the past something caused us to load a whole batch of data, and now I have discovered a problem with this load.

       

      Fortunately, we load the file name in the initial load and save the data to a QVD.

       

      I want to "fix" this data, first by excluding the bad data from the QVD.

       

      I was hoping I could use something like this:

      FROM

      [P:\QlikView Storage\Data Sources\QVDs\PO_Final.qvd]

      (qvd)

      where FileName < > 'PO_DUMP_02-25to07-18.csv'

      ;

       

      Unfortunately QV doesn't like <> for not equal on the QVD load. Could somebody help with the syntax here, I have tried a bunch of diffreent things.

      Thanks