Hi, How to achieve interpolated between years and get the values? Source 1: YearValue11.345621.4567832.22345642.9876551.987661.3245671.43567882.21345690.98765102.123456 Target: IDYear_1Interpolated_value1002.124Interpolated (((2.223456-1.45678)/(3-2)) * (2.124-2) + 1.45678) =1.5518478241013.987((2.98765-2.223456)/(4-3)) * (3.987-3) + 2.223456 = 2.9777154781026.12Interpolated between 6 and 71035.432Interpolated between 5 and 61049.765Interpolated between 9 and 101058.432interpolated between 8 and 910671.4356781074.378interpolated between 4 and 5 Thanks, Mark

Hello @mark_paul, getting here the exact same results. If there is one which differs from yours pleas tell me to see where to perform the change. If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Regards

Interpolation between Years

mark_paul

Hi,

How to achieve interpolated between years and get the values?

Source 1:

Year	Value
1	1.3456
2	1.45678
3	2.223456
4	2.98765
5	1.9876
6	1.32456
7	1.435678
8	2.213456
9	0.98765
10	2.123456

Target:

ID	Year_1	Interpolated_value
100	2.124	Interpolated (((2.223456-1.45678)/(3-2)) * (2.124-2) + 1.45678) =1.551847824
101	3.987	((2.98765-2.223456)/(4-3)) * (3.987-3) + 2.223456 = 2.977715478
102	6.12	Interpolated between 6 and 7
103	5.432	Interpolated between 5 and 6
104	9.765	Interpolated between 9 and 10
105	8.432	interpolated between 8 and 9
106	7	1.435678
107	4.378	interpolated between 4 and 5

Thanks,

Mark

Developer Tools

Dynamic Processing

Data Investigation

Accepted answers

afv2688

Hello @mark_paul,

getting here the exact same results. If there is one which differs from yours pleas tell me to see where to perform the change.

Sin título.png

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

interpolation.yxmd

RolandSchubert

Accidentally removed the "Group by" on ID in the Multi-Row Formula - now it's back and there is only one result for each ID.

InterpolatedValues.yxmd

All comments

patrick_digan

@mark_paul I've attached an example using the ceil and floor function to join the 2 data points and then calculate the output.

community 2020-01-22 interpolation.yxmd

mark_paul

@patrick_digan ,

Thanks for your quick response.

what if one of the year is missing? for example year 8 is not available in the source then need the interpolation between 7 and 9. How to achieve this?

Year	Value
1	1.3456
2	1.45678
3	2.223456
4	2.98765
5	1.9876
6	1.32456
7	1.435678
9	0.98765
10	2.123456

Thanks,

Mark

afv2688

Hello @mark_paul ,

Does this help?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

interpolation.yxmd

RolandSchubert

Hi @mark_paul ,

it's possible to o it using Transpose and Multi-Row Formula tool. I've attached a sample workflow.

Best,

Roland

InterpolatedValues.yxmd

mark_paul

@afv2688 ,

Its not working for below source when interpolating between 7 and 9 for computing the 8.432

Year	Value
1	1.3456
2	1.45678
3	2.223456
4	2.98765
5	1.9876
6	1.32456
7	1.435678
9	0.98765
10	2.123456

Thanks,

Mark

mark_paul

@RolandSchubert ,

I tried with below source data its not working for interpolation between 7 and 9 when computing 8.432 value?

Year	Value
1	1.3456
2	1.45678
3	2.223456
4	2.98765
5	1.9876
6	1.32456
7	1.435678
9	0.98765
10	2.123456

Thanks,

Mark

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703