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

[Anusha_Mavuluri_TCSL]

How to group repeated email ids present in one column of data table.Can anyone please help me

[Dominic]

@Anusha_Mavuluri_TCSL, Use this,

How to get count of unique values in column2 of the datatable

@Naveen @arivu96 You can use group by here (From row in dt.select() Group row by Product=Convert.Tostring(row.Item(“Program”)) Into Group Select Group(0)).ToArray.CopyToDataTable() Regards, Mahesh

Regards,
Dominic

[arivu96 (Arivazhagan A)]

Refer this post

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

[Anusha_Mavuluri_TCSL]

Hi Dominic,

Thanks a lot could you please explain more i am not able to get it completely.

[arivu96 (Arivazhagan A)]

Hi @Anusha_Mavuluri_TCSL,

@Dominic

(From row in dt.select()
Group row by Product=Convert.Tostring(row.Item(“Program”)) Into Group
Select Group(0)).ToArray.CopyToDataTable()
Regards,
Mahesh

(From row in DataTableName.select() Group row by Product=Convert.Tostring(row.Item("EmailID")) Into Group Select Group(0)).ToArray.CopyToDataTable()

This code will return the unique record of email id

Regards,
Arivu