Read and compare table (excel)

KNIME Analytics Platform
1

Hi,
experts, I need your help. I’m new hier.
I’m trying to read excel File and compare some columns inside ohne table

  1. I have in column a=part a
    column b =part b
    column c= result (e.g -3,5mm or 4,8mm)
    column d=requirement (5mm)

If column a=part a and column b =part b and the difference between Result and Requirement = equal or less then 0,2mm than write column e=OK

If difference between Result and Requirement = larger then 0,2mm than write column e= Not OK

Any hint is welcome

Thank you

2

Use Excel reader to load table in KNIME and Rule Engine for comparison.

3

Hi, thank you.
Reading of the table was not the problem, but the Rule engine.

Thanks I will try that
Drago

4

I have tried he Rule Engine but I couldn’t enter the tolerance

5

Western standard assumes dot not comma.
(result -requirement <= .2) and (result -requirement >= -.2 )=> “OK”
TRUE => “Not OK”

6

Hi,
thank you for the Answer, but it doesnt work. Te reason is, there is no operator “minus” in Rule Engine:

Drago

7

Hi there!

You can use first Math Formula Node to calculate what you need and then Rule Engine node :slight_smile:

BR,
Ivan