Hi all, I have been searching the forum but cant find any help. I have a data table DT1 that contains approx 20 columns. I would like to do a group by, insert the result in a new data table DT2 and do a left join between DT1 and DT2. How can I accomplish this? DT1: Order ID, Serial No, Amount, C…

Hi all! Any ideas how to do this “left join”?

@cristian_ivanoff DT2= (From p In dt1.AsEnumerable() Group By x= New With { Key.a =p.Item(“OrderID”),Key.b=p.Item(“SerialNo”)} Into Group Select Group(0)).ToArray().CopyToDataTable() Create a Create a List of strings ListA=(From p In DT1.AsEnumerable() Group By x= New With { Key.a =p.Item(“…

oh ok. Didnt update the site so didnt see your answer. Thanks @MAHESH1 I will try immediately… //c

@MAHESH1 I’m sorry but I’m not used to the syntax. I get this error message. I try to search for answers but cant find any… [Error_20180321]

[image] MAHESH1: (From p In dt1.AsEnumerable() Group By x= New With { Key.a =p.Item(“OrderID”),Key.b=p.Item(“SerialNo”)} Into Group Select Group(0)).ToArray().CopyToDataTable() Use this one @cristian_ivanoff (From p In dt1.AsEnumerable() Group By x= New With { Key.a =p.Item("OrderID"),K…

Thanks @arivu96 Are the quotes the difference?

I got this error message now and Im lost in space…Dont know what to do…“Hides a variable”…when im trying to create a list of strings… [Error_20180321_2]

@cristian_ivanoff Try this once DT2= (From p In dt1.AsEnumerable() Group p By x= New With { Key.a =p.Item(“OrderID”),Key.b=p.Item(“SerialNo”)} Into Group Select Group(0)).ToArray().CopyToDataTable() Just add p Regards, Mahesh

No difference. Same error. What language is this anyway?

@cristian_ivanoff Try this it might help you ListA=(From p In DT1.AsEnumerable() Group By y= New With { Key.a =p.Item(“OrderID”),Key.b=p.Item(“SerialNo”)} Into GroupA= Group Select Convert.ToString(GroupA.Sum(Function(x) Convert.ToDouble(x.Item(“Amount”).ToString)))).ToList() Even here also yo…

Group by - Data table

Help

arivu96 (Arivazhagan A) April 27, 2018, 4:37am 16

DataTable =DataTable.DefaultView.ToTable(true,"Account","Type").Select("Account='CA'").CopyToDataTable()

or
DataTable =DataTable.Select("Account='CA'").CopyToDataTable()

Refer this one for DataTable operations

Regards,
Arivu

Topic		Replies	Views
Group by in UiPath Help	6	6863	March 15, 2020
Group Datatable Activities datatable , excel , activities , bug , datatable-filter	5	513	January 28, 2024
Linq Query, Please Help! Reboot Your Skills 2021 week-4	8	2004	May 5, 2021
Datatable - Grouping Data on 3 Columns - Split on different Data Tables Studio	6	3580	March 12, 2022
Linq Group By and Sum Help datatable , studio	13	18626	April 26, 2020

Group by - Data table

Related topics