How to create records in Table AND Update (rename) fields of records

[MalikB]

If "Equipment Status" is "Decommissioned" and the value found for "Sub-State" is "Digital Collection", then rename the value to:

- External Reuse.

3. MAPPING RULES

Table Action	Resource State	Resource Substate	Configuration Item State	Configuration Item Substate	Synchronization Direction	Active
Modification	Decommissioned	Recycled	Decommissioned	Digital Collection External Reuse	From Resource to Configuration Item	True
Modification	Decommissioned	Digital Collection External Reuse	Decommissioned	Digital Collection External Reuse	Both	True
Creation	Decommissioned	For Spare Parts	Broken	For Spare Parts	From Configuration Item to Resource	True
Creation	Decommissioned	For Spare Parts	Decommissioned	For Spare Parts	Both	True

hardware_ci_status = Configuration Item State
hardware_ci_substatus = Configuration Item Substate
asset_state = Resource State
asset_substate = Resource Substate
active = Active

synch_direction = Synchronization Direction