Return latest date from a duplicate row

[acdeleon123 (Aleo Ralph)]

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)

[ppr (Peter Preuss)]

Give a try on

(From d in dtData.asEnumerable
Group d by k1=d(“Customer PO No”).toString.Trim, k2==d(“Part No”) into grp=Group
let lr = grp.OrderBy(Function (x) CDate(x(“Planned Delivery Date”).toString.Trim))
Select lr).CopyToDataTable

Maybe we have to adopt the date conversion

[acdeleon123 (Aleo Ralph)]

Hi on what part do I implement this?

[ppr (Peter Preuss)]

within an Assign acitvity
left side: dtResult | DataType: DataTable
rigth side: the LINQ from above

Also have a look here:

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode th…

[acdeleon123 (Aleo Ralph)]

Hi, I’m having a problem please check

@ppr

(From d in dtData.asEnumerable
Group d by k1=d(“Customer PO No”).toString.Trim, k2==d(“Part No”) into grp=Group
let lr = grp.OrderBy(Function (x) CDate(x(“Planned Delivery Date”).toString.Trim))
Select lr).CopyToDataTable

[ppr (Peter Preuss)]

AsEnumerable is not a member of 'System.Data.Datatable'

Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference> Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup.

May we ask you also on the Edition (Studio / Studio Pro) and the version whcih you are using? Thanks