Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
cooldamselcooldamsel 

[Urgent]Update using Data Loader!!!

Hi,

I am a newbie in salesforce. Can anyone please explain me how to solve the following scenario using data loader.

I have two objects: object1 and object2. The two objects have a common column 'global id'. There are 50000 records in object1. My scenario is when the column values are equal in two objects, i need to update object1.

Can anyone please provide a solution for this?

Thanks in advance.
Best Answer chosen by cooldamsel
praveen murugesanpraveen murugesan
Hi,

I think you need to use VLookUp

Thanks,
Praveen Murugesan

All Answers

Swati GSwati G
Hi,

Do you have csv file to perform update on object1 or you want to extract object2 and then update its values on object1?
praveen murugesanpraveen murugesan
Hi,

I think you need to use VLookUp

Thanks,
Praveen Murugesan
This was selected as the best answer
cooldamselcooldamsel
Hi swati,

I want to extract object2 and then update object1 if a specified column value in object1 and object2 are equal.
Swati GSwati G
You can create that common field as external id and perform upsert or you can use vlookup as praveen suggested on microsoft excel. Using vlookup you can match the common field and save one columns as object1 id and perform update on it.
praveen murugesanpraveen murugesan
Vlookup is one way. for the solution.

Else

You can write the bulk trigger. 

That will have two or more maps that will update only when the values in two columns where equal.

ie, put columns matched values in map or list then update only those records.

Please mark this as best answer if you got the solution.

Thanks.

Praveen Murugesan.
cooldamselcooldamsel
Ho to use vlookup. I am not clear on it. Can yo please explain me?