Data Validation

KG16
Tera Contributor

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 

 

 
6 REPLIES 6

KG16
Tera Contributor

Yes all fields on forms there are 90 columns coupls of them are custom

HugoFirst
Kilo Sage

If you can compare the record manually, you should be able to script something to compare them automatically.  The important thing is to have a field to act as a key between the two tables.  If you have that, it should be feasible to write a script to compare each record in one table to it's counterpart in the other.    Can you say what specifically stops you from doing this?