Remove duplicate value from reference type field

[Madhurima2]

Hello,

How to remove duplicate value from reference field using advanced reference qualifier in ServiceNow? Kindly help.

Thanks in advance.

[Saurav11]

Hello,

Please check the below post:-

https://www.servicenow.com/community/developer-forum/how-to-display-only-unique-values-from-the-refe...

Please mark my answer as correct based on Impact.

[Manmohan K]

Hi @Madhurima2 

Instead of adding advanced referenced qualifier, why don't you investigate the reason behind the duplicates in the table you are referencing . If they are true duplicates, then discuss with your team and get the data cleaned up

[Ankur Bawiskar]

@Madhurima2 

I agree with point mentioned by Manmohan.

Please discuss the same and share the updates.

[Madhurima2]

Hello Ankur,

This field value is associated with different records so we can not cleanup the table. This field value is particularly work as a reference field of a different table.