Partial where not exists?

Tue, 14 May 2013 11:15:24 GMT

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 Number	Company Number	Product Code	Customer Name	Value	Site	Area	etc	etc
12-GB-1234	12345	456	Test	3490	N1	UK	etc	etc
13-GB-3452	45908	7889	Test1	5400	N2	UK	etc	etc

Spreadsheet Exceptions

Order Number	New Company Number	New Product Code	New Customer Name
12-GB-1234	7899	23453	NewTest
13-GB-3452	89000	78349	NewTest1

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 Number	Company Number	Product Code	Customer Name	Value	Site	Area	etc
12-GB-1234	7899	23453	NewTest	3490	N1	UK	etc
13-GB-3452	89000	78349	NewTest1	5400	N2	UK	etc

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

Re: Partial where not exists?

er_mohit — Tue, 14 May 2013 12:23:28 GMT

see the attached file

Re: Partial where not exists?

Tue, 14 May 2013 12:44:46 GMT

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.

topic Partial where not exists? in QlikView

Partial where not exists?

Re: Partial where not exists?

Re: Partial where not exists?