2 Replies Latest reply: May 14, 2013 8:44 AM by Ralph Graham RSS

    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