hello everyone, I need to group the rows in which columns A,B and C are equal. Then I would like to aggregate the values of the OLD and NEW columns. In the image, at the top the original datatable and at the bottom the one I expect. I cannot find a suitable linq, can you help me? [image]

Linq group by and concatenate

raja.arslankhan (Raja Muhammad Arslan khan) August 26, 2022, 11:55am 2

please fallow these steps,
1-use read range activity
2-use filter data and set keep and give input and output data table.
3 further i am looking

Topic		Replies	Views
Group by Studio	3	633	November 19, 2022
LINQ: group data and concat Studio datatable , activities , linq , linq-query	5	345	February 10, 2024
LinQ query for grouping the specific column and sum the column Studio excel	4	600	June 22, 2023
Group data table by value and join results in caret list Help question	6	2751	June 11, 2020
LINQ for grouping, sum and copy to new DT - skip not working Studio studio , question , designer_canvas , linq	6	159	June 23, 2024