Remove Positive & Negative Entries

Hi,

I want to remove Positive and Negative entries basis Sales Number, From & To location and fetch Unique Bill number rows.

Weight Bill number Date Sales number Bill type From To
50 11112222 19-06-2022 123456 Invoice Pune Mumbai
-50 22223333 22-06-2022 123456 Cancel invoice Pune Mumbai
40 33334444 25-06-2022 123456 Invoice Pune Mumbai
60 55556666 30-06-2022 123456 Invoice Pune Mumbai

Output should be as below,

Weight Bill number Date Sales number Bill type From To
40 33334444 25-06-2022 123456 Invoice Pune Mumbai
60 55556666 30-06-2022 123456 Invoice Pune Mumbai

Can someone help here.

Regards,
Samir

Hi @Samir_Nagure

Your description is not very clear but what I understand from it based on your desired output is that you want to remove all negative weight values and its absolute equivalent?

A way to do it:

  • Convert the negative values to positive.
  • Sort on weight, billnumber, from and to.
  • Check for duplicates on weight, billnumber, from and to.
  • Only keep unique records.

WF: Remove Positive & Negative Entries.knwf (27.9 KB)

Please clarify if this is not what you meant.