Data Validation

[KG16]

I have a requirement to perfrom validation between two tables and  with record and their field values in CMDB for almost 2000 such records.

Manual testing is complex for each record and not feasible we need to compare data for all 2000 records and their relationships. Is there a way to achieve this via script which gives output of variation and matches found.

Any help will be apperciated this is in reference to records of applications moved from application software to business application wherein data is copied and needs to be compared for data validation for field values 

[Saurabh Gupta]

Hi,
Do you want field to field validation.
are both tables have the same backend name of the fields?

Please let me know.

[KG16]

This is relaed to two different tables with field to field mapping two tables are Business application and application software where records are copied into Business application tables with same fields

[Saurabh Gupta]

do you have all the fields to be be compared?

[reshmapatil]

Hi @KG16 ,

Check this:

https://www.servicenow.com/community/now-platform-articles/compare-field-values-between-multiple-rec...

Regards,

Reshma

**Please mark my answer correct or helpful based on the impact**