Hi,
How to return latest date from a identified duplicate rows? For example, I have here a row which has the same Customer PO No and Part No but it has different Planned Delivery Date.
Order No | Customer PO No | Part No | CONCATENATE | Status | Quantity | Sales Price | Planned Delivery Date |
---|---|---|---|---|---|---|---|
8218665 | 4505295951 | 01690-001 | 450529595101690-0018 | Released | 8 | 551.00 | 7/1/2021 |
8218665 | 4505295951 | 01690-001 | 450529595101690-00110 | Released | 10 | 551.00 | 8/1/2021 |
So what I want to return is latest Planned Delivery Date
Order No | Customer PO No | Part No | CONCATENATE | Status | Quantity | Sales Price | Planned Delivery Date |
---|---|---|---|---|---|---|---|
8218665 | 4505295951 | 01690-001 | 450529595101690-00110 | Released | 10 | 551.00 | 8/1/2021 |
I’m using the workflow from Identify the Duplicates and sum the value credits to @ppr.
I have here attached the sample data and the workflow.
LINQ_2KeyGroupIn.xaml (10.8 KB)
Book1.xlsx (11.4 KB)