Multi-Row and File Combine

Question

Hi,

I would like a combine Output

Input file attached and Part of the Workflow

Multiple rows data should be Grouped by the Sr.ID

End Result - should be as below -

Sr.IDArrivalsSaleVersionTypeAmountAdvanceDiscount123789Last SeasonSale Item1CREDIT4000_USD00.3123852Last SeasonSale Item1 1000_GBP;350_GBP  147852Last SeasonSale Item1 8000_USD 0.25159159Last SeasonSale Item1CREDIT2000_USD;500_USD0 159753Last SeasonSale Item1 1000_GBP  232323Last SeasonSale Item1CREDIT7550_USD;1000_USD-0.35 111133Last SeasonSale Item1DEBIT6000_EUR;350_EUR-500 874125Last SeasonSale Item1DEBIT5000_EUR00.05222159Last SeasonSale Item1 5000_USD;500_USD;50_USD00.25;0.1963741New ArrivalsSale Item1DEBIT3000_USD5000.25159712New ArrivalsSale Item1CREDIT2500_USD2500.1

End of Day_Inventory.yxmd

Sale Inventory.xlsx

binu_acs · Accepted Answer

@EmilAlteryx01 One way of doing this

binu_acs · Accepted Answer

@EmilAlteryx01 updated my workflow to reflect the correct input file sort order