Replacing group names only in Catalog Items

[Lavanya11]

Hi all,

I have an Excel Sheet with old Group Names and New Group Names. In our Catalog Item(sc_cat_item) table, we have a custom field which reference to the group Name. Now I need to replace all this old group names with new group names according to the Excel List. So what is the best procedure to do it? Is transform map a best idea or packing sys_ids of the group in two different properties will be a good idea?

[Chetna_dev]

When you need to update records based on data from an external source like an Excel sheet, using a transform map is generally the recommended approach. It provides a structured and manageable way to handle data imports and updates in ServiceNow, and it allows for flexibility in data manipulation using scripting when needed.

[Dhananjay Pawar]

Hi,

It is just a name change of assignment group so you can use the transform map.

After name change it will automatically reflect wherever it is referenced.

Thanks,

Dhananjay.

[Dhananjay Pawar]

Hi,

Please mark the solution as accepted so in future people will refer same for similar kind of issue.

Thanks.