I have two data tables of values that are spatially mapped, but the coordinates of one table are not the same coordinates as the second. I would like to "Join" these tables but have the data match by coordinate so I can compare the spatially variant values between the two tables. Does anyone know if there's an easy way to do this instead of just brute force calculating for every value? There looks to be some interesting matrix functions but I am unfamiliar with the mathematical concepts behind them. I have a mockup of the process shown below that hopefully conveys what I want to have happen. View more... (Highlight to read)XYV000101202011112223022123224 + XY0.50.51.50.50.51.51.51.5 => XYI V0.50.511.50.520.51.521.51.53 XYV000101202011112223022123224 + XY0.50.51.50.50.51.51.51.5=> XYI V0.50.511.50.520.51.521.51.53

Matching Spatially Inhomogeneous Data

Accepted answers

Maybe this would be helpful How to do Bilinear Interpolation using JMP?

There also seems to be Scripting Guide > JSL Building Blocks > Conditional Functions > Interpolate > Bilinear Interpolation (jmp.com) but I haven't used that.

All comments

jthi

I think VPTree() or Distance() could work here (maybe KDTable()), but what do you do in ties?

Not looking for closest points but rather points in same line and interpolation after that if I understood correct.y.

txnelson

I do not understand how you come up with the value for IV. Could you please explain the rules you are using?

Resonator_Drift

IV was the interpolated value of XYV (Table 1) from the table, using the coordinates from the XY (Table 2) table