This content has been marked as final. Show 2 replies
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).
|Order Number||Company Number||Product Code||Customer Name||Value||Site||Area||etc||etc|
|Order Number||New Company Number||New Product Code||New 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
|Order Number||Company Number||Product Code||Customer Name||Value||Site||Area||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.