Remove duplicate rows depending on the condition

Duplicate.zip (79.9 KB) Can someone please help me to understand how I can remove the duplicate values depending on the 2 columns in Data Table

For Example: Data Table having the column name “POnumber” contains the Duplicate Data and also need to check the column “Email” to make sure it is duplicate or not. Then need to remove those duplicate rows and lets say present new DataTable in new Sheet


I attached the file.
Can any one please share a Studio solution please

You can create a subset of this Dt with required fields (Using FilterDt activity use output columbs tab) then use Remove Duplicate Rows activity to remove duplicates and output that to a new Dt. Based on the screenshot provided the Email Subject and PO number seems to be the unique fields. If you are not concerned regarding rest of the columns, this should work…