Data Quality Match header for each suject area for dates

[VJ_88]

Hi,

We need to perform DQ check after each month file load.

Scenarios

1. Each month file is been sent and appended one after another
2. Each area has 02 types of record 
   1. Header - similar to table header 
   2. Value - Actual value
3. Each month a new column could be added but needs to be at last
4. 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

[abacon]

@VJ_88 What you will want to use are either the Test tools or Message tools. You have the ability to create rules/standards in your workflow.

You will need to use control containers to ensure the error handling runs before the rest of the workflow.

https://help.alteryx.com/current/en/designer/tools/developer/test-tool.html#test-tool

https://help.alteryx.com/current/en/designer/tools/developer/message-tool.html

Bacon