Conditional filtering

Hi all,

I need some help regarding conditional filtering. I tried to look for solutions but was not able to find any.

Basically, I need to filter based on a hierarchy key on column Year and Type. For example in this, A is higher than and F is higher than O. E.g. for 1234 in 2022 since both O and F exist, we just want F. However, in 12345 2023, only O exists so we will take O. X and Y are misc columns whose data should be kept. At the very end, only one row for each year should exist.

Any help is appreciated.

alteryx example.png

Workflow

Accepted answers

@np123 one way of doing this with the batch macro

DynamicFilter_050224.yxzp

@np123 Inside the macro i took the min value in the given year, you can change it according to your requirement

All comments

@np123 one way of doing this with the batch macro

DynamicFilter_050224.yxzp

Awesome, how did you specify which "type" is outputted?

@np123 Inside the macro i took the min value in the given year, you can change it according to your requirement

In this case it takes the lower ASCII value, is that correct?

Excellent, this is a good start to help figure it out thanks.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703