coalesce is not working and is inserting records

Nisha30
Kilo Sage

‎11-13-2024 07:33 AM

Hi Experts,

 

We have simple excel sheet for loading the CI in database table however even though we have coalesce for NAME and Ignore = TRUE, it is inserting duplicate records instead of updating.

 

We only have NAME (as coalesce =true) as there is no IP and Serial number or other attributes to match to.

 

This is strange can anyone please suggest why is this.

 

Thanks

0 Helpfuls
  • 281 Views
1 REPLY 1

Ravi Peddineni
Kilo Sage

‎11-13-2024 07:53 AM

@Nisha30 

 

What CMDB table are you inserting the records into? and what is the class of those CI records?

0 Helpfuls