Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Data filtering logic

Neico
7 - Meteor

Hello,

 

I'm trying to figure out a multi-step filtering logic for my data:

 

IDAffected byTypeWeight
1Ainactive0.6
1Bactive0.4
2Cinactive1
3Ainactive0.4
3Bactive0.2
3Dactive0.4

 

I would like to keep rows under the following criteria:

  • if they are unique --> keep row for ID 2
  • if ID is a duplicate then keep if there's a single Type = "active"
  • if ID is a duplicate and there are multiple Type = "active" then keep the one with the highest value under Weight

The resulting table should thus be:

IDAffected byTypeWeight
1Bactive0.4
2Cinactive1
3Dactive0.4

 

Thank you for your help!

2 REPLIES 2
ImadZidan
12 - Quasar

Hello @Neico ,

Just an idea with just using tools.

 

Hope it helps.

Neico
7 - Meteor

So simple but effective. Thank you!

Labels