AnsweredAssumed Answered

Duplicate table lookup

Question asked by robin.zhang344808 on Oct 10, 2018
Latest reply on Oct 11, 2018 by 51662476

Hi, everyone


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.