I have a table only contains ID and duplicate ID, which is a static table (will not be updated). I could either save this table within salesforce or a CSV file on a FTP site. The integration process requires retrieved records from salesforce to lookup ID with static table and retrieve all corresponding duplicate ID. And merge them into one table.
The challenge is 1) lookup duplicate ID 2) merge or append duplicate ID with the same value fields
I first thought to do a cache lookup, but realize it would not work for duplicate index ID. Please let me know if there is way to do it. Appreciated.