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.
