Comparing fields from two separate tables and flagging duplicates

madicrane — Mon, 09 Sep 2019 19:18:07 GMT

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.

Re: Comparing fields from two separate tables and flagging duplicates

DavidM — Tue, 10 Sep 2019 14:10:02 GMT

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)

topic Comparing fields from two separate tables and flagging duplicates in App Development

Comparing fields from two separate tables and flagging duplicates

Re: Comparing fields from two separate tables and flagging duplicates