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:
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.
where (not FileName = 'PO_DUMP_02-25to07-18.csv')
View solution in original post
Thanks, I appreciate the help.