Filter out records based on two criteria.

KNIME Analytics Platform
#1

Greetings,

I have a dataset that looks like this:

ACCOUNT | ATTEMPTS
Account #1 | 1
Account #1 | 2
Account #1 | 3
Account #1 | 4
Account #1 | 5
Account #1 | 6
Account #2 | 1
Account #2 | 2
Account #2 | 3
Account #3 | 1
Account #4 | 1
Account #4 | 2

Each account has multiple entries with different amounts of attempts. What I want to do is to look at each account and take the largest attempt number and the other data associated with that row and ignore the records that have lower attempt numbers per account. So the output would look like this:

ACCOUNT | ATTEMPTS |
Account #1 | 6
Account #2 | 3
Account #3 | 1
Account #4 | 2

Any help would be appreciated. Thank you and look forward to your reply.

Signed,
John

#2

@jhandatx,

I think the Duplicate Row Filter solves your problem.

Select the account as the column for duplicate detection and in the advanced tab under select row chose the attempts column and choose maximum of.

Hope that solves your problem helps :slight_smile:
Mark

3 Likes
#3

Perfect. Thank you Mark :smile:

Signed,
John

2 Likes
#4

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