
Re: Bilinear interpolation in PI AF tables
David Hearn Aug 16, 2018 1:07 PM (in response to PierreEH)6 of 6 people found this helpfulBilinear interpolation for AF Tables is now supported in the PI AF 2018 (2.10.0) release. See 'Examples of linear and bilinear interpolation in table lookup data references' topic in the documentation.

Re: Bilinear interpolation in PI AF tables
PierreEH Aug 17, 2018 5:22 AM (in response to David Hearn)Thanks David for the quick and helpful answer. I guess the ball is in my IT dpt now.
Pierre

Re: Bilinear interpolation in PI AF tables
PernilleSilberg Aug 17, 2018 8:34 AM (in response to David Hearn) a comment from the IT Dpt @Pierre
using the function: as in the example  we get thrown the following: The expression contains undefined function call INTERPOLATE().
when we use the example referred to in the answer above  by the way in the expression in the example there are too many "end"parentheses:
your expression: SELECT Velocity FROM Table1 WHERE INTERPOLATE([X Horizontal Position]), @X) AND INTERPOLATE([Y Vertical Position]), @Y)
I count 2"(" and 4")"
David; could you pls. comment on this.

Re: Bilinear interpolation in PI AF tables
Eugene Lee Aug 17, 2018 9:01 AM (in response to PernilleSilberg)2 of 2 people found this helpfulHi Pernille,
Thanks for reporting this. This syntax works for me.
SELECT Velocity FROM Table1 WHERE INTERPOLATE([X Horizontal Position], @X) AND INTERPOLATE([Y Vertical Position], @Y)

