Multiple Column GroupBy SQL Query

[hss]

Hi Team, I have a dataTable and i would like to perform a multiple column groupby query on it. Something like this -
SELECT SUBJECT, YEAR, Count(*) FROM Student GROUP BY SUBJECT, YEAR;

Any help would be appreciated as to how to convert this into uipath acceptable format.

[PrankurJoshi]

Hello @hss

You can try this

(From dt1 In yourDatatbale.AsEnumerable()
Group dt1 By 
c1=dt1("SUBJECT").ToString.Trim,
c2=dt1("YEAR").ToString.Trim
Into Group
Select dataTableVariable.Rows.Add({c1,c2, Group.COUNT()})).CopyToDataTable

Thanks,
Prankur

[hss]

@Prankur thank u