How to aggregate data in datatable using LINQ in uipath(Group by Operator)

Опубликовано: 04 Октябрь 2024
на канале: One Minute RPA with Mannoj
494
2

This video will describe how to use Group by operator to aggregate the data in a datatable using LINQ using Uipath

Here is the query to group by the data

(From row In dt_InputData.AsEnumerable
Group row By key=row.Item("Region").ToString.Trim Into grp=Group
Let new_row_data = {key, grp.Sum(Function(y) CDbl(y.Item("Total"))).ToString}
Select dt_OutputData.rows.add(new_row_data)).copytodatatable

Code: https://github.com/manojbatra071/UiPa...


#rpa #uipath #OneMinuteRPA #uipathrpa #uipathstudio