How to remove duplicates in excel on keywords

[Pradeep_Shiv]

Hello guys
i’ve to delete particular row which is repeating i’ve to retain the first row value and delete the rest

[Sasi.lalo (Sasikumar)]

Hi @Pradeep_Shiv,

Please check this link:

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)< >''"…

[KarthikByggari]

Remove duplicates in excel

Hi I want to remove duplicate rows by comparing the rows of the same column. If the content of row1 is ma to row 2 then delete row1 and so on till the end of selected rows. example column1 abc abc def abc output abc def abc plz proveide the solution with xaml file. Thanks

Regards,
Karthik Byggari

[SrenivasanKanna (Srenivasan kannan)]

@Pradeep_Shiv

You can use - Remove Duplicate Rows Activity

Please refer this page for further details:

Activities - Filter and Delete Rows in Excel Files

Other helpful source from @HareeshMR

Remove the duplicate row

I haven’t tried that @balkishan But here is the example for that , check this Remove Duplicates Range.zip (10.0 KB)

Regards,
Srenivasan Kannan

[KarthikByggari]

we have an inbuilt activity now. Also check the below one -

Remove Duplicates Range

Regards,
Karthik Byggari

[Pradeep_Shiv]

i’ve to delete one particular value not all other duplicats

[HareeshMR (Hareesh Madasi)]

You mean you want to delete the duplicate of one particular row and leave the rest?
Go with VB code to do the required @Pradeep_Shiv

[Pradeep_Shiv]

exactly ,how do i do that

[HareeshMR (Hareesh Madasi)]

1. Loop through the headers of the excel
2. check for the particular header you have
3. Initialize the variable of type integer and then assign it to 1
4. Continue the loop and if the same value occurs again, increment the value by 1 and then delete the entire column so that you will remove the second occurrence of that header.