Field Normalization

[Appy2]

Hi All,
If anyone worked on field normalization,please let me know how can we normalize reference field (like department on user table).

Requirement is to normalize user's department when creating new record.
It seems OOTB servicenow does not support normalization on reference field.

So there is any way to normalize reference field. 

If any idea kindly share here.

Thanks,

[Satishkumar B]

Hi @Appy2 
refer this below article:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0784201

…………………………………………........................................................................................
Mark it helpful 👍and Accept Solution ✅!! If this helps you to understand.

…………………………………………........................................................................................

[Narsing1]

Hi,

Are you looking to normalize Department Name in cmn_department table / are you looking to update the Users department field with a proper reference?

First case, you may need to go with transformation instead of Normalization.

In the second case do you have any Raw field where you are getting some raw value related to Department and wanted to update the Department field properly?

Some example would be good to provide a solution.

Thanks,

Narsing

[Appy2]

Hi @narshing1,
Thanks for your reply.
I need to update Department table on the user table,so that once user record gets create department field should updated with Normalization value.
Or as per your reply my case would be second, as of now i dont have any raw field on the user table but i can create but the issue it how to normalize the department field as its a reference field.

Let me know if i was unable to explain it to you?

[Narsing1]

Hi @Appy2 

Got it. Please go through with the below Article

Field Normalization for a Reference Field 

Thanks,

Narsing