Advance Excel filter

Hi
I need to filter the table.
Im looking at column Putch.doc. The goal is to remove duplicate PO numbers and leave only single PO number, but additionally I have to look at column Conf Type and if I have several lines for one PO number once with Conf Type ‘AB’ and once without I have to keep the line where Conf type is empty.

My input
aPNG
and what I want to leave
b

Excel file with input and expected output
1.xlsx (12.3 KB)

1 Like

Hi @niteckam,

you can use Remove Duplicate Rows activity and mention the column name or index

Cheers
@niteckam

Fine but I do not know how to add the condition this is not only remove duplicate activity I have additional assumption which I have to include