How to find coalesce field in Robust Transform

[Saib1]

Hi ,

How to find the coalesce field in Robust Transform ?

[VaranAwesomenow]

I see that your screenshot is from the RTE definition of ETL. ETL doesn't generally have coalesce defined.

ETL follows IRE, hence identification rules define how records are updated / inserted.  You should be looking at below.

https://instance.service-now.com/cmdb_identifier_list.do?sysparm_userpref_module=5b10d2b79f233100d3921a1cf67fcfd3&sysparm_clear_stack=true

[Saib1]

Hi Anil,

So you mean that RTE definition doesnt have coalesce field?

then when updating on the same data. How it will works?

which fields does it use to coalesce to decide whether to import or update a CI

My ETL definition is empty 

[Saib1 · Accepted solution]

I resolved it 

I found the Coalesce fields in RTE Entity Operation 

Use Unique Input Sets as coalesce in Robust Transform

 

[jtshone]

nothing in there for Intune.....

[VaranAwesomenow]

@Saib1  If its ETL then coalesce wouldnt be needed at entity level, it should get handled using CI identifiers, assuming you are loading CI data.