Coalesce without creating records

[jared_wentzel]

I am trying to update our users with their room numbers from a excel file with coalesce on the User's ID. The problem is there are a lot of extra users on this Excel spread sheet and when I run the transform it is creating new users for every user id it cannot find a match to. How do I use the coalesce option to update existing records and not create new records?

[nick_2586]

write a script in transform map as below :

if(action == "insert")

{

ignore = true;

}

[jared_wentzel]

That kept it from updating any existing records as well.

[haldroid]

Nisheeth's answer should work. We use that approach all the time.

What are your fieldmaps? Is there more than one coalesce field?

Is the ignore ... code in an OnBefore transform map script?

[jared_wentzel]

I just put it on the transform map itself, where should I put the code for it to work correctly?