Merging non-unique rows in DT

Help
, ,
1

Hi
I have this simple datatable, with some rows being there multiple times.
datarows
I would like to merge the non-unique lines, so that my end result would be like this with summed prices for and with one line for each itemnumber.
datarowsdone

Is there an easy way to merge the rows by summing up column “PRICE” and keeping itemnumber and qty.

The excel is just for showing, the data will be kept and handled as a datatable.

1 Like
2

See the use of LINQ for this here:

You could also use Pivot Table activities to achieve the required results

3

Very nice, i will have a look into that, thanks !

4

Hello @MarkusDS

As Also suggested by @ronanpeter this can be easily done using LinQ

I recreated the same scenario(Datatable) and applied LinQ query on it to get the desired result.

Check this workflow for better understanding

GroupBY.xaml (8.0 KB)

1 Like
5

Same, put together this which should help:

GroupBySum.zip (2.1 KB)

6

Thanks @ronanpeter and @vickydas

It works perfectly and it is kept as a DT so i can process it futher, thanks :slight_smile:

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.