How does Coalesce True work with use source script

[Prathamesh Cha1]

Hi Team,

I am using coalesce true on this field which has source script, if sys_id matches with target table reference field sys_id it should Update it, which is not happening. can you help me in this?

[Allen Andreas]

Hello,

Well, what is happening? Is it creating a new record? Or just not updating it?

if it's not updating it, then there's a separate problem most likely going on where the incoming data isn't mapped or the system doesn't see anything to update.

Your post isn't clear if you're saying the problem is that you're getting new records instead of updating what is there...please tell us more more information and screenshots help.

[Prathamesh Cha1]

Hi @Allen Andreas ,

It is inserting new records rather than updating exiting one.

Following is the run script I am using for Ignore RAM which dont have state = publish

following 2 fields I have made coalesce true. if entity and current RAM from excel sheet matches with entity and Risk assessment Methodology, it should Update the record. and if current record is empty then only insert it

Following is the excel sheet example

This is working in lower instance but not in higher instance.

Combination does exits to update the record

[Sumanth16]

Hi @Prathamesh Cha1 , 

Can you check your query in your script. 

Try to run this script in background script by doing changes and check what is the sys_id is printing. 

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Thanks & Regards,

Sumanth Meda

[Prathamesh Cha1]

Hi @Sumanth16 ,

yes this is working in background script.