Interpolation between Years
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@mark_paul I've attached an example using the ceil and floor function to join the 2 data points and then calculate the output.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @mark_paul ,
it's possible to o it using Transpose and Multi-Row Formula tool. I've attached a sample workflow.
Best,
Roland
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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 as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @mark_paul ,
Have updated the workflow. Forgot to add something
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @mark_paul,
Added a nice touch to filter out all the fields that are out of the interpolation limits.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
