Forum Discussion
Best Practices: Data Validation
Hey Team, Does anyone have any best practices regarding finding data issues in reports? For example, the company I work in will occasionally change master data on orders, which will cause report ...
Hi kvonck34,
The basic idea is comparing the master data in the orders with the original data. So the problem could be as follows now.
1. Where is the original data that we can consider as correct data?
2. How do these tables connect?
3. Do they have any key column that can identify every record? If not, how can we tell if the master data is changed or it's new?
Can you share a small sample? Please mask the sensitive parts first.
Best Regards,