Hello,
I have two source file one is source and another target.
Source :
| Contract_Number | Contract_Item_Number | Product_Code | Annualized_Amount | Contract_start_date | Contract_end_date |
| 30515758 | 740 | 2000014273 | 5209.09 | 6/8/2026 | 6/7/2027 |
| 30515758 | 580 | 2000014273 | 4914.23 | 6/8/2025 | 6/7/2026 |
| 30515758 | 500 | 2000014273 | 4592.74 | 6/8/2024 | 6/7/2025 |
Target:
| Contract_Number | Contract_Item_Number | ProductCode__c | AmountPrice__c | AmountPrice2__c | Amount_Price_3__c | Amount_Price_4__c | Amount_Price_5__c | Amount_Price_6__c | Amount_Price_7__c | EndDate__c | AmountAllocatedFinal__c | Year2AmountAllocatedFinal__c | Year3AmountAllocatedFinal__c | Year4AmountAllocatedFinal__c | Year5AmountAllocatedFinal__c | StartDate__c | Year1Amount__c | Year1EndDate__c | Year1StartDate__c | Year2Amount__c | Year2EndDate__c | Year2StartDate__c | Year3Amount__c | Year3EndDate__c | Year3StartDate__c |
| 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 |
Consolidation Logic:
1. Consolidation done based on the same Product_Code , Contract Number ,Contract_start_date & Contract_end_date
2. We can see AmountPrice__c -> mapped from the Annualized_Amount based on the First Contract_start_date & Contract_end_date
3. Similarly AmountPrice2__c ->mapped from the Annualized_Amount based on the second Contract_start_date & Contract_end_date & Contract_end_date
4. Same logic is applied through the other columns AmountAllocatedFinal__c , Year2AmountAllocatedFinal__c ,Year3AmountAllocatedFinal__c
5. Also, Date columns are also populated in similar fashion.
Can someone help me how to create Alteryx workflow for above problem statement ?
