+ Start a Discussion

Reference to lookup fields in formula by data upsert with Jitterbit


I try to upsert data from production to a dev sandbox. To have all lookup relations in the Sandbox, I need to define a cross reference formula to every lookup in production. For example if I have on an object lookup to account, I need the formula Customer__r.ExternalID__c. So I can map this field in Jitterbit and I have the relation in my sandbox
The problem is, when I have many lookups on an object I need to define also many formulas, and I cannot have more than 10 cross reference formulas on an object.
When I have many lookups to Account on one object, I cannot wrap them in a formula field and use this field by the mapping.

Does anyone have an idea?