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