in my table are rows with several information columns. One of these columns is an integer column. Each integer value in this column can appear more than once, so it is not necessarily unique, but it can be unique.
Now I want to take all of the rows that have values in this integer column, that are the tenth biggest values or bigger.
So I want the rows with the biggest values in there, the second biggest etc. until the tenth biggest.
Has anyone an idea how I can manage to do that?
Hopefully I was able to explain, what I want to do.
Me again. You could use a Group By node to identify the tenth biggest value (This makes the values unique). You could then make this number a variable (Table Row to Variable Node) and use this to as a row filter node to find all rows with this number or greater. I think this will work
to get n rows with the highest or lowest values in a specific column is pretty simple now with Element Selector node. To have RowID or Row number in a separate column use String Manipulation node after Element Selector with substr() function on ROWID column.
@joan to add Element Selector into KNIME there are couple of possibilities. Either Drop&Drag node icon into your KNIME Analytics Platform from link I provided or go File --> Install KNIME Extensions and find Active Learning extension after which you follow steps for installing it.
@izaychik63 currently not but in feature maybe! Will check it and get back to you.
This makes sense and feature request has been made for it.
This one brings questions what row to keep when there are ties and that logic is implemented in Duplicate Row Filter node so it doesn’t make sense to have it copied to this node as well. Simply run Duplicate Row Filter node before Element Selector