Help - Registration Evaluation

KNIME Analytics Platform
1

Guys,

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

2

@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.

2 Likes
3

managed to do it using column expressions nodes

ex:

image
image939×874 151 KB

1 Like
4

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