Value lookup for each column in a table

[imagejan]

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?

Thanks,

Jan

 

[christian.birkhold]

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!

 

Cheers,

Christian

 

• example_timeseries.zip

[imagejan]

Hi Christian,

thanks a lot for the great example!

 

Cheers,

Jan