In my example below I have two different attributs: the asset and group, group A being highest priority then B and then C. I would like to keep only 1-A, 2-B , 3-C and 4-A. How do you filter the other ones out?
Asset - Group
1 - A
1 - B
1 - C
2 - B
2 - C
3 - C
4 - A
4 - C
If they are ordered like that, you can simply use a duplicate filter with the Key Attribute set to Asset. This will keep the first occurrence of each asset.
Thank you. Unfortunately my group names are not A, B, C but rather values that can not be sorted alphabetically to be in priority order.
@katt Try using the Aggregator. Use a Group Processing / Group By of you groups (A,B, etc). In the Aggregator, set it to create a list or the priority attribute - _priorityList{}. Then sort the list using the ListSorter. You should be able to pick of the first element (_priorityList{0}) as the highest priority.
I think the StatisticsCalculator with Group Processing / Group By and Maximum Value might give you the same result.