Linear interpolation between range values

[mark_paul]

Hi All,

How to compute the Linear interpolation between range of values?

Source Table:

ID	VAL
123	3.13
124	4.22
125	2.35

Lookup Table:

low_val	high_val	pct
2	2.25	110.25
2.5	3	112.2
3.25	3.5	115.25
3.75	4	120
4.25	4.75	125

ID-123 is interpolated between 

2.5	3	112.2
3.25	3.5	115.25

Interpolated value= (3.13 - (2.5+3)/2)/((3.25+3.5)/2-(2.5+3)/2) * (115.25-112.2) + 112.2=114.0544

Target:

ID	VAL	Interpolated_pct
123	3.13	114.0544
124	4.22	122.76
125	2.35	110.952

Thanks,

Mark

[RolandSchubert · Accepted solution]

Hi @mark_paul ,

you can use Append Fields, Filter and Sample to solve the problem:

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland