Update all records when transform map matched the multiple records, coalesce is on one field only

[D_R]

Update all records when transform map matched the multiple records, coalesce is on one field only.

Can we update all matching records?

[Rashmika BS]

if the records are duplicated and if we have retired one of them, will it still update the retired one? coz thats what happening in our case. duplicate records one is active and another one is Retired but each time Retired CI gets updated 

[Anamika Gupta]

Are you using coalesce ? Could you give me more information about your query if possible attach screenshot also

[Rashmi Rao]

Yes Coalesce on Serial number and name. We have an integration from where we are receiving the server updates. Target table is cmdb_ci_server.  We dont have any onbefore script. 

[Anamika Gupta]

If you are using coalesce. So first IRE check for matching record if found it will update the record (no matter if value is retired) else create new record.

[Rashmika BS]

Ok.. so transform scripts Onbefore can avoid updating retired CIs?