Ui Path Group by Function Error

Help Studio
,
1

Error is displayed while using Group by Please some can answere this issue
I’m not able to use group by function in Ui Path using Linq

2

Can you share the code you are using

4

@Taruna_Gupta

Assign activity: groupedData = yourDataTable.AsEnumerable().GroupBy(Function(row) row(“ColumnName”)).CopyToDataTable()

5

Hi @Taruna_Gupta

Share your linQ query and requirement. Then it will be better for understanding to check the error.

Hope it helps!!

6

dt2.AsEnumerable().GroupBy(Function(row) row(“Sale Price”).ToString)

7

Hi @Taruna_Gupta

At last you have to give what type you want to change if you want to change it to List use below

dt2.AsEnumerable().GroupBy(Function(row) row.Field(Of String)("Sale Price").ToString()).ToList() ' You might need to convert the result to a list or another data structure if required.

To convert to datatable :

dt2.AsEnumerable().GroupBy(Function(row) row.Field(Of String)("Sale Price").ToString()).CopytoDatatable()

Hope it helps!!

8

Hey @Taruna_Gupta,

If you want to convert it back to datatable you can use the below Linq,

dt2.AsEnumerable().GroupBy(Function(row) row("Sale Price").ToString).Select(Function(Group) Group.First).CopyToDataTable

If you want the result as a list or array to iterate through everything, you can use
dt2.AsEnumerable().GroupBy(Function(row) row("Sale Price").ToString).ToList

9

dt2.AsEnumerable().GroupBy(Function(row) row(“Sale Price”).ToString)

image
image713×154 5.27 KB

10

image
image713×154 5.27 KB

11

Sorry for the issue, can you try
dt2.AsEnumerable().GroupBy(Function(row) row("Sale Price").ToString).Select(Function(Group) Group.First).CopyToDataTable

12

(From row In dt2
Group row By a=row(“Sale Price”).ToString Into grp=Group
Select grp.first
).copyTodataTable

1 Like