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