Value lookup for each column in a table

Dear all,


is there a KNIME node that can perform value lookup and return the rowID using a given rule?

For example, I have several time series in a table:

Time TimeSeries1 TimeSeries2 TimeSeries3
0 0.0 0.1 0.0
1 0.2 0.2 0.5
2 0.6 0.3 0.9
3 0.7 0.4 1.6
4 1 0.5 3.5
5 1.2 0.6 3.9
6 1.9 0.8 5.2
7 2.3 1.1 8.0
8 9.0 1.2 12.5


Now I would like the first time point for each time series where the value >= 1, so the expected output shoud be:

  TimeSeries1 TimeSeries2 TimeSeries3
TimePointOfInterest 4 7 3

Any hints on how to best perform this analysis?




I would do it for each time-point individually using `Column List Loop Start` node. Then I would filter out all time-points with < 1.0 using the `Row Filter` and then I would use a `Row Filter` to only get the first row of the table. Afterwards you can use the `RowId` node to write the `RowId` in a column. The `Loop End Column Append` finishs the loop.

Maybe someone has a more elegant solution, but the example workflow (see attachement) I created for you also works!





1 Like

Hi Christian,

thanks a lot for the great example!




This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.