Conditional filtering

[np123]

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. 

[binuacs · Accepted solution]

@np123 one way of doing this with the batch macro

[np123]

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

[binuacs · Accepted solution]

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

[np123]

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

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

[binuacs]

@np123 yes