Starting November 20, the site will be set to read-only.
On December 4, 2023,
Apex Code Development (90768)
General Development (55146)
Visualforce Development (37251)
Lightning (18265)
APIs and Integration (17146)
Trailhead (11680)
Formulas & Validation Rules Discussion (11337)
Other Salesforce Applications (8116)
Jobs Board (6655)
Force.com Sites & Site.com (4842)
Mobile (2694)
You need to sign in to do that
Don't have an account?
Rima Hi All,
I have data in two access tables that needs to be transferred to a Salesforce object. Two tables are related but can be mapped to single object in Salesforce. How to import two related tables to a single Salesforce object? Could any one please let me know the steps? I greatly appreciate your help.
You could either :
1) Produce One flat file outside of salesforce with data from the two tables aggregated and upload into Salesforce via DataLoader
2) Follow a 2-step upsert into Salesforce. Get two csv extract files from your external system. You would need to define an External Id field for the object in salesforce for this. In Step 1, Upsert from the first csv file using DataLoader. In Step 2, Upsert from the second csv file. In each case match on the External Id field, so that the upserts can be de-duped by the external id.