Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

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?

Hello,

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
12-GB-123412345456Test3490N1UKetcetc
13-GB-3452459087889Test15400N2UKetcetc

Spreadsheet Exceptions

Order NumberNew Company NumberNew Product CodeNew Customer Name
12-GB-1234789923453NewTest
13-GB-34528900078349NewTest1

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
12-GB-1234789923453NewTest3490N1UKetc
13-GB-34528900078349NewTest15400N2UKetc

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.

Thanks,

Ralph

2 Replies
er_mohit
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.