Problems deleting duplicate Records
Hello everyone,
I’ve already learned quite a bit about Knime Analytics (version 5.4.5), but now I’m at my wit’s end and I can’t find any information that helps me. I want to delete duplicate records that have the same value in the “BELEGNUMMER” column, but different values in the “CPUDATE” and “CPUTIME” columns. It doesn’t matter which duplicate record remains. For other deletions, I use the “Rule bases Row Filter” where I have direct information about what should be deleted.
This, for example, doesn’t work with the “Rule bases Row Filter”:
$BELEGNUMMER$ = $BELEGNUMMER$ AND NOT $CPUDATE$ = $CPUDATE$ AND NOT $CPUTIME$ = $CPUTIME$ => TRUE
because, like my other attempts, it returns an empty table.
Can anyone help me with this?
Thanks and best regards,
Holger