Checking Duplicate rows depending on the condition

Hello Everyone,

Can someone please help me to understand how we can remove the duplicate values depending on the 2 columns in Data Table and also need to copy those duplicate rows into separate Data Table.

For Example: Data Table having the column name “Supplier/Customer Name” contains the Duplicate Data and also need to check the column “Credit LC” to make sure it is duplicate or not. Then need to copy the duplicate in a separate sheet.

I have used the Remove Duplicate Rows Activity which is not working. I hope this activity check each and every column depending on the AND Condition. But in my scenario I have to apply the condition only on the above mentioned two columns.

Much appreciated for your kind help in advance


Hi @winningvish,
Please check our forum as there are many topics which covers this area:


Hi @winningvish

Check this post

DataTable filtering with expressions