Give Score row wise

[ravi13]

Hello Knime Expert!!

Hope You are doing well.

I am little bit confuse in giving score to each ratio as provided below pic:

Requirement:
1st Row give us Cash flow Ratio of Year 2018 & 2019.
Now I want to give Score where if
Ratio is <20 Score= 0
Ratio is <25 Score= 20
Ratio is <30 Score= 40
Ratio is <35 Score= 60
Ratio is <40 Score= 80
Ratio is >=40 Score= 100

For Current Ratio Score would be as below:
Ratio is <0 Score= 0
Ratio is <1 Score= 20
Ratio is <1.5 Score= 40
Ratio is <1.75 Score= 60
Ratio is <2 Score= 80
Ratio is >=2 Score= 100

And likewise for every Ratio scoring would be different… But I want scoring of all in Single Column…
in this manner

[mlauber71]

I think you could use the rule engine and include the row ID in the condition

Rule Engine

If it gets more complicated the Java snippets might be an option.