We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Consolidation Logic for multiple Rows into Single

prawal1990
6 - Meteoroid

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_NumberContract_Item_NumberProduct_CodeAnnualized_ValueContract_start_dateContract_end_date
3051575850020000142735209.092026-06-08

2027-06-07

3051575874020000142734914.232025-06-08

2026-06-07

3051575850020000142734592.742024-06-08 

2025-06-07

Target

Contract_NumberContract_Item_NumberProductCodeAmountPriceAmountPrice2Amount_Price_3Amount_Price_4Amount_Price_5Amount_Price_6Amount_Price_7EndDateAmountAllocatedFinalYear2AmountAllocatedFinalYear3AmountAllocatedFinalYear4AmountAllocatedFinalYear5AmountAllocatedFinalStartDateYear1AmountYear1EndDateYear1StartDateYear2AmountYear2EndDateYear2StartDateYear3AmountYear3EndDateYear3StartDate
3051575850020000142734592.744914.235209.09    6/7/20274592.744914.235209.09  6/8/20244592.746/7/20256/8/20244914.236/7/20266/8/20255209.096/7/20276/8/2026
10 REPLIES 10
prawal1990
6 - Meteoroid

Thanks Abacon for your support . It means a lot to me. 

Labels
Top Solution Authors