Datatable - Grouping Data on 3 Columns - Split on different Data Tables

[andreus91]

Hello,

I have a datatable composed of 4 columns, as in the image:

I need to group the rows that have the same “Number” AND “Name” and “Code” column values as follows:

The result in the example should return me 8 datatables.

Any idea to achieve this?

Thanks!

[postwick (Paul Ostwick)]

https://www.google.com/search?q=uipath+group+datatable+site:forum.uipath.com&safe=active&rlz=1C1GCEA_enUS956US956&sa=X&ved=2ahUKEwj3h-ezlrn2AhVOZN8KHVcXASIQrQIoBHoECBAQBQ&biw=1920&bih=937&dpr=1

[Palaniyappan (Palaniyappan P)]

Hi

Have a view on this thread for some idea

How to split datatable based on Group by and values in a column in Linq Query? Please Help

I need to split datatable into two datatables based on Group by and another column values. From the Source Datatable, I need to move records based on Group by columns “Col 1” and “Col 2”. In addition, if the values in the “Col 3” contains “I” & “A”, then the set of records should be moved to new datatable (DT1). And rest of the Source Datatable should be moved to another new datatable (DT2). Please help me to solve this. What I have: Source Datatable: [image] What I need: In a New Datatabl…

Cheers @andreus91

[Gokul001 (Gokul Balaji)]

Hi @andreus91

Have a look on the thread

How do I group by one column in the datatable and take the sum?

@jamnanin I will suggest you one more way try like this. Let us take your excel stored in a datatable dta First group the datatable based on ID by using below Query and assign it to dt1 dt1=(From p In dta.Select() Group p by ID=p.Item(“ID”).ToString Into Group Select Group(0)).ToArray.CopyToDataTable() Now take only two columns by using below query dt1=dt1.DefaultView.ToTable(False,“ID”,“Name”) Now Add one datacolumn to dt1 by using add datacolumn activity and give name Amount to that c…

Regards
Gokul

[ppr (Peter Preuss)]

assign Activity
LHS: TableList | List(of DataTable)
RHS

(From d in YourDataTableVar.AsEnumerable
Group d by k1=d("Name").toString, k2=d("Number").toString, k3=d("Code").toString into grp=Group
Select t=grp.CopyToDataTAble).toList

Also Have a look here:

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

[andreus91]

Thanks to all, i’m signing your solution as the correct one!