Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Partial where not exists?


I have a qvd that has 50+ rows of data and want to exclude parts of a row which an Order Number already resides in a spreadsheet (used to clean up any exceptions).

QVD Table

Order NumberCompany NumberProduct CodeCustomer NameValueSiteAreaetcetc

Spreadsheet Exceptions

Order NumberNew Company NumberNew Product CodeNew Customer Name

So I want to replace the Company Number with the New Company Number, Product Code with the New Product Code, and Customer Name with the New Customer Name, as well as maintaining the other fields (Value, Site, Area etc) that is from the original table. The below table is what I want to have as the end result

New Table

Order NumberCompany NumberProduct CodeCustomer NameValueSiteAreaetc

I have tried where not exists on the QVD Table but this will obviously purge all the data in that table that is assigned to the Order Number. Any help would be appreciated.



2 Replies
Honored Contributor II

Re: Partial where not exists?

see the attached file

Not applicable

Re: Partial where not exists?

Thanks, will that solution still work when there are orders that aren't on the spreadsheet, i.e. not all orders will be on the exception spreadsheet and as such should not be changed at all.