"Filter of highest values?"

lists

Hello,

I read the doc. but did not find the right answer.

Filter rows with the 5 highest values of an attribute?

Would this be possible possible?

Is there an expression?

I think it could be some kind of cascading filters or easier with a math expression (max etc.), but have no idea how to do so.

I'm also interested in a unique-filter (no duplicated values of an attribute).

Thank you.

lists

Update: got it...had to use another subprocess for the db-actions.

Thomas_Ott

If you want the Top 5 values you could use a Sort operator and then a Filter Example Range operator. Sorty for decscending direction and then use 1 to 5 for the Filter Example Range.

lists

Thank you Thomas,

unfortunately this gives me with parameter first example=1 and last example=2

240 rows. I also noticed that in my case, operator "Generate id" produces duplicated ids...

http://docs.www.turtlecreekpls.com/studio/operators/blending/examples/filter/filter_example_range.html

PS: I try to write performance data of your modified example to a Sqlite-db.

It seems I have to use db-mode 'overwrite'...hm a little strange, since I want to produce an archive.

I guess RM writes sequentially into the db. So I would need some kind of caching (maybe).

I'm aware of remember & recall. But how to trigger recall only if validation has finished?

Would this be macro stuff?