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 idea what to do next, since wrong rows can be removed.
the example Excel file is attached
Thank you