Good forums everyone, I have a table in a datatable type as seen below. In this table, I will make a calculation for purchases for the same material number. I will calculate the difference between the most current international and the most current domestic purchase. I need to pull and process the …

Hi, How about the following sample? [image] dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("Place of Purchase").ToString,r("Material Number").ToString )).Select(Function(g) g.OrderBy(Function(r) CDate(r("Purchase Date"))).Last()).CopyToDataTable Sample20231013-4L.zip (9.3 KB) Regards,

How to group a datatable?

Help Studio

ppr (Peter Preuss) October 13, 2023, 8:16am 2

A general intro:

1 Like

Topic		Replies	Views
Datatable Group Studio linq , linq-query	3	265	October 20, 2023
[HowTo] Overview on different options for grouping data and processing the groups Tutorials datatable , activities , bestpractices , faq , community_tutorial , linq	3	9680	April 2, 2022
Linq with if Condition and Datatable Update Studio studio , question , workflow_diff	8	684	November 3, 2023
Group by Country and Rate from Data Table Studio datatable , activities , studio , linq , data-manipulation	5	688	January 31, 2023
DataTable - Process particular member from a group Studio	2	977	October 8, 2021

Most Active Users - Yesterday
ashokkarale
KevinE
Anil_G
Rule_Outlaw
lrtetala
A_Learner
Kanika_Saluja
More details...

How to group a datatable?

Related Topics