Hi All,
I need your help to create a workflow in Alteryx . I am stuck while applying consolidation logic . I have two input files one is source and another is target
Expected Result
Consolidation logic is applied based on the Product_Code, Contract_Number,Contract_start_date,Contract_end_date
Can you help me to generate one Output file which consolidate this source and Target columns along with the Match & Mismatch for all the above columns.
Another type of source data is when product code is different for same Contract Number then no consolidation will be happen. so we need to handle those as well
Source
| Contract_Number | Contract_Item_Number | Product_Code | Annualized_Value | Contract_start_date | Contract_end_date |
| 30515758 | 500 | 2000014273 | 5209.09 | 2026-06-08 | 2027-06-07 |
| 30515758 | 740 | 2000014273 | 4914.23 | 2025-06-08 | 2026-06-07 |
| 30515758 | 500 | 2000014273 | 4592.74 | 2024-06-08 | 2025-06-07 |
Target
| Contract_Number | Contract_Item_Number | ProductCode | AmountPrice | AmountPrice2 | Amount_Price_3 | Amount_Price_4 | Amount_Price_5 | Amount_Price_6 | Amount_Price_7 | EndDate | AmountAllocatedFinal | Year2AmountAllocatedFinal | Year3AmountAllocatedFinal | Year4AmountAllocatedFinal | Year5AmountAllocatedFinal | StartDate | Year1Amount | Year1EndDate | Year1StartDate | Year2Amount | Year2EndDate | Year2StartDate | Year3Amount | Year3EndDate | Year3StartDate |
| 30515758 | 500 | 2000014273 | 4592.74 | 4914.23 | 5209.09 | | | | | 6/7/2027 | 4592.74 | 4914.23 | 5209.09 | | | 6/8/2024 | 4592.74 | 6/7/2025 | 6/8/2024 | 4914.23 | 6/7/2026 | 6/8/2025 | 5209.09 | 6/7/2027 | 6/8/2026 |
