Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
pduplessis
New Contributor II

Where Clause in QVD load

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

(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

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Where Clause in QVD load

try

FROM

(qvd)

where (not FileName = 'PO_DUMP_02-25to07-18.csv')

;

2 Replies
Not applicable

Where Clause in QVD load

try

FROM

(qvd)

where (not FileName = 'PO_DUMP_02-25to07-18.csv')

;

pduplessis
New Contributor II

Where Clause in QVD load

Thanks, I appreciate the help.

Community Browser