Data Validation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2022 09:23 PM
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
- Labels:
-
Architect
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-26-2022 02:09 AM
Yes all fields on forms there are 90 columns coupls of them are custom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2023 10:48 AM
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?