Group column by name

[CamiCat]

Hello friends,
@rkelchuri, @Ninett_Panfir, @Rammohan91, @balupad14, @Florent_Salendres, @vvaidya, @Palaniyappan, @ClaytonM, @vvaidya, @lakshman, @Dave,

I need to extract the datatable from the Excel and to collect the equal names in the column “Ragione sociale/BU”.
I need to group equal names in the column , so group the values in the column “Ragione sociale/BU”.
How to do that?
Can you please share a xaml?

Cami

[Palaniyappan (Forum Leader)]

Hope this thread would help you

How to group repeated email ids present in one column of datatable

@Anusha_Mavuluri_TCSL, Use this, Regards, Dominic

Cheers @CamiCat

[balupad14 (Balamurugan)]

Hi @CamiCat,
How are you ? After a long time… Is it possible to read the data into the datatable and do the group by using the below activity.

UiPath Go ! Datatable Activities

Hi All, Here you can get the datatable related activities. This package includes the below activities that can handle the Aggregation, Cumulative, Add - Delete row range and Export to Xml 1.Add Data Row Range. 2.Remove Data Row Select. 3.Group By Aggregation (Sum,Count,Avg, Max, Min). 4.DataTable to XML Document. 5.DataTable to XML File. 6.Sum,Count,Avg, Max, Min. Name Space [image] [image] https://go.uipath.com/component/datatable-related-activities Regards Balam…

Regards
Balamurugan.S

[CamiCat]

hello @Palaniyappan,

I need to order the datatable by column value.
The group function deletes some rrows.
How to do that?
Cami

[Dave (David Wiebelhaus)]

@camicat - Can you expand what you mean by “group equal names” - specifically, what do you mean by group? Also, later on you say you want to order the datatable by column value. Is that a separate question?

Can you provide an example input and the expected output?

[sanjay21051990 (sanjay shankhla)]

Hi @CamiCat,

Below is the Sample it take the Sub-group and compute the MAX

attached the Below Script
Group_By_Query.zip (18.5 KB)

Regards
Sanjay Shankhla