Normalization

[surya123]

Hi All

I want to normalise the model id field of CI. But since it is a reference field , it says to normalise in the base table.

When discovery is running it is feeding the model id field and this in return creates a Model if not existing in model table. What i see is it feeds the display name with model id from CI and keeps the model name field blank.

Now when I normalise the Name field of Model, it would change the display name of model which in tun would modify and update the model id field of CI. But when discovery runs again and gets a new CI inserted with a model name which is existing but it dont find it as its name was normalised and display name of model is changed , so it will go ahead and crate a new model?

What process will be better to normalise the model data being fed to CI table?

[shan101]

Try to achieve this with the help of Raw field Normalization. The Orginal value will be in the raw field and you can map the Raw field

[shan101]

http://wiki.servicenow.com/index.php?title=Normalizing_and_Transforming_Field_Values#Raw_Fields

[surya123]

There are multiple values for a single data and raw field will just capture the 1st one .

[shan101]

The Raw field should be introduced before Normalizing the data. So that the Normalized value will be same but the raw fields are diffrent.