Duplicate Row filter

Hi Team,

Hope you are well.

While using joiner(Left outer) I am getting duplicates so I used duplicate row filter to remove the duplicates but duplicates are not removed.

So I tried on different column combinations to remove but still, the issue is there either I am getting more or I am getting less no. of line items.

In excel 1 - Total no. of line items: 217803

In excel 2 - Total no.of line items:154774

After using Joiner (Left outer): 229606 (I want as per excel 1)

Joiner based on Doc. No.

I am getting duplicates

So, I used Duplicate Row Filter: 215109

On different column combinations different no. of line items.

Can you please suggest how to remove duplicates.

Thanks