Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
see the attached file
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.