Help - Registration Evaluation


I have a big messed up accounts table with a lot of duplicated registers within it. (salesfoce)
The objective is simple, identify the duplicates and choose the register with most imputs.

if possible, create a score sistem, giving each column a specific value, to sum up at the end so i can simply use the duplicate row filter to choose the max from this sum.

couldnt do it using rule engine without having to create a node for each column
any ideas?

i’m using 5.11 for this development

thanks guys

@YuriRibeiro welcome to the KNIME forum.

One node that might help is the:

You can define operations for several columns at once and the later aggregate the results. Or you could loop thru a set of columns and use operations.


managed to do it using column expressions nodes


1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.