I am interested in creating a PI AF Attribute that returns the value of a column when a certain PI Point Attribute is between two values from a reference Table.
For example, for the table below, I'd like to return the appropriate value from [Output Value] for a given PI AF Attribute input.
Here, the PI Point is called as @[PI AF Attribute], which is dynamic and will change continuously.
SELECT [Output Value] FROM [Example Table] WHERE [Low Range] <= @[PI AF Attribute] AND [High Range] <= @[PI AF Attribute]
For example, if @[PI AF Attribute] were to equal 8.5, I'd expect the output to be 5.
|Low Range||High Range||Output Value|
However, the PI AF SQL type query returns 'None' as an output when I attempt this within PI AF for my real data (see attached).
I am not sure how to achieve this table lookup given.
Any suggestions would be highly appreciated.
I understand this would be simpler with Interpolation, but I am trying to avoid that.