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 450…

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

Hi on what part do I implement this?

within an Assign acitvity left side: dtResult | DataType: DataTable rigth side: the LINQ from above Also have a look here: [image] [HowTo] Overview on different options for grouping data and processing the groups Tutorials This HowTo introduces on the differ…

Hi, I’m having a problem please check [Untitled] [image] 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

[image] AsEnumerable is not a member of 'System.Data.Datatable' Help 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 cre…

Return latest date from a duplicate row

Help Activities

ppr (Peter Preuss) June 17, 2021, 9:29am 6

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

Topic		Replies	Views
Select newest record when there's a duplicate Studio datatable , excel , activities , studio , question	2	1184	June 16, 2021
Multiple row has same order nos but need to extract unique order.Please find the below example screenshot Academy Feedback question , faq	2	784	July 25, 2020
LinQ query help regarding duplicates Studio studio , linq	21	657	March 4, 2024
Getting the duplicate vaues by comparing date from datatable Help	4	1078	December 2, 2018
Delete Duplicate Excel Rows Based On One Column Studio studio , question , activities_panel	7	2768	November 3, 2021

Return latest date from a duplicate row

Related topics