Task Location Normalization

[_bhishek]

Hi All,

I have duplicate location with name in location table .So currently task table records(INC,sctack ,req,RITM e.tc.) are mapped with both locations .I want to map all tasks with one location .So that i can remove another duplicate location .
FYI -I have already cleaned up users ,CMDB ,Asset tables with below approach .
In Field normalization>>Normalization field types -Created reference field type  and transform category as location.
Then configured transform definition as below -

function(variables, value, parameters) {
    // Convert incoming value to string (should be a sys_id)
    var val = value + "";

    // Map of incorrect Sys IDs to correct ones
    var locationMapping = {

        "9e471f0b13ddef00e56ebf304244b08f": "24b8bf2e0a0a3c5700acc9aaf9438611", //LA
      

        // Add more mappings as needed
    };

    // If the value matches an incorrect sys_id, replace it with the correct one
    if (locationMapping.hasOwnProperty(val)) {
        val = locationMapping[val];
    }

    return val;
}

Then configured the transformation under field normalization with Task table and mapped the transform definition in same .
This is working fine in user, CMDB and asset table but in task table since notification are configured .What should be the best approach to deal this situation here and also we should not update fields like updated by or updated on.
Please advise .Any pointer would be helpful.