In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data imputation across multiple columns

oliverd
7 - Meteor

How should I do a linear interpolation for the following example data:

 

oliverd_0-1658762550953.png

so that I get the following result:

 

oliverd_1-1658762597279.png

 

2 REPLIES 2
Amol_Telore
11 - Bolide

Hey @oliverd 

 

Here is my solution. Feel free to reach out to me in case of any concerns.

 

FYI, I have pivoted data first so that we don't need to use Multi Row formula multiple times and you can have it for N number of fields.

oliverd
7 - Meteor

Very nice thank you

Labels
Top Solution Authors