AnsweredAssumed Answered

PI AF - Table Lookup Data Reference BETWEEN two values in table

Question asked by Mattpdrexel on Dec 5, 2018
Latest reply on Dec 6, 2018 by Mattpdrexel

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.


Attempted Query:

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 RangeHigh RangeOutput 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.