Hi,
We need to perform DQ check after each month file load.
Scenarios
- Each month file is been sent and appended one after another
- Each area has 02 types of record
- Header - similar to table header
- Value - Actual value
- Each month a new column could be added but needs to be at last
- if any field of previous month does not have data header should be there with blank values
- We need to check
- for each Subject area all header records
- Should be matched if there are aligned
- Example
- Subject Area - SUPPLY CHAIN, has 02 months of data we need to match if F1,F2,F3,F4,F5,F6 has same values in Header.
- For HR area it should fail because for 31-01-2025 Column G in Header (F4 has COURIER) whereas in 28-02-2025 it has H1 , please find attached
- months for each area will get adding up
