Hello, I have a topic that unfortunately was closed, so I cannot add more comments now. The link: Duplicates removal The workflow that was offered by @goodvirus perfectly worked, however when i tried to implement it to more sophisticated files, unfortunately, it didn’t. The new problem I am facing is: If there are more same rows, then the duplicates are being identified only based on one row. Hence, all negative transactions are being removed but all positive ones are still there. If someone could share with me their ideas on how to remove those, would be great. The new example file is attached You can follow the link for reference to the initial topic [image] Duplicates removal KNIME Analytics Platform Knime example .xlsx (9.3 KB) Hello everyone! I would appreciate it if someone can give me an idea of how to solve this problem in Knime. The task is to remove the same duplicated rows if the conditions are met: 1. All data except Value are same 2. The 2 same rows can be removed only if the Value of the first one is negative and second one is positive of the same number ( example 15 and -15) I have tried to convert negative number to positive using abs function of a math node, but have no i… @goodvirus could you please also have a look? Thank you very much!!! :pray: Knime example1 .xlsx (9.2 KB)

Duplicates removal

mlauber71 February 15, 2022, 12:28am 2

I cannot look at the example right now. But you could try and use a window function (creating a rank per group and sort of the rest) to identify the right row you want to keep