Datatable group by with sum

[ramu_at]

Hi All,

can you please share some sample for how to do group by using multiple columns including sum with datatable?

-ramu

[ClaytonM]

Hi.
It might be more sustainable to avoid GroupBy and depends on your requirements, but you can check out this discussion where we tried to solve for this:

Linq Group By and Sum

Hi there! I’m facing some problems trying to generate a consolidated Datatable using Linq (GroupBy and Sum). I have an ID column on my Datatable (not unique) and some Double values, like an Invoice ID and it items with different values. I’d like to generate a new Datatable with an unique invoice ID and sum it’s values. Here are some methods that I’ve tried. Some of them return an error informing that UiPath uses Strict Only, hence my sintax does not explicit declare the data ty…

Regards.

[AshwinS2 (Ashwin S)]

Hi @ramu_at

Check the below post

Sum column of datatable in uipath

Thanks
Ashwin.S