Filter row Which occur just above the specified number of value

[vedaantt]

I want to select the rows which comes above the value 95 in the column
eg
col1
1
2
70
95
30
40
95.7
40
78
96

i want to have the rows of
col1
70
40
78

[Mark_Ortmann]

Hey @vedaantt,

this should solve your problem (minor modifications required).

Finding values where the previous row's value was less than or equal.

Hello, I’ve been trying to create a workflow that will highlight any rows that have a value that is less then or equal to the previous row’s value. I thought of using the Lag Column to add the previous rows value and then use the row filter to remove any that are greater than the previous value, but I don’t think there is a way to do that with the row filter. Am I going about this the right way? Thanks, Kevin

[vedaantt]

Sorry but it was not helpfull in my case
thanks for answering though

[HansS]

Hi @vedaantt
What do you mean by above the value 95 in the column . And how does this lead to 70, 40, 78?

[Mark_Ortmann]

I’m very sorry to hear that.
Could you please specify in more detail why that solution is not working for you? Maybe I’m not totally understanding your problem

[vedaantt]

Its the Percentage data as you may have got it
i only want the value that leads the data to go above 95
so i want that breaking point

thus afet 70, 40,78
the value barrier cause to pass 95
thus the result table need to show that value

[vedaantt]

because its returning all value less than 95 not one value that leads to pass 95

[Mark_Ortmann]

Btw. adding Counter Generation Node and Table Sorter (descending based on the counter) before the lag column would also work. Rule-based row filter has to be adapted anyways.

[armingrudd]

Hi,

Here is my suggestion:

Filter_to_95.knwf (27.1 KB)

Feel free to ask any question.

[vedaantt]

thank you again sir