Comparing fields from two separate tables and flagging duplicates
I need to compare two separate fields from salesforce that are in separate QVD files. The opportunity qvd file pulls in the expiring contract id # and the contract QVD file pulls in all contracts id #'s. If there is a match in the expiring contract # and all contracts #'s the contract has been renewed and I need to flag when this happens.
Technically these fields are displaying the information different with different api names but they are looking at the same unique contract #'s.
The new contract # links to the origin opportunity which includes the expiring contract id #. From this I know if a contract has been renewed or not.
I suppose the tables are linked or joined via the contract ID. IF that is the case it is pretty simple: In the load from expiring QVD create flag field with value 1. Then if you want to list those contracts you use the flag field (in set analysis for example)
