I have a data set that I have some values that need to be interpolated values and extrapolating others. The data is set up as the same:
RecordID Model Variable Level Value
The formula to do this in excel is as follows if one value is null:
Row-1:Value]+([Row-1:Value]-[Row+1:Value])/([Row-1:RecordID]-[Row+1:RecordID])
That works and is verified.
However, if there are two null values, or three null values, then you choose the value before and the next value with that value set. The first question surrounds how to choose the next filled in value and set that?
Example:
The above shows two null values. If I were to use excel, it would be 656Value+(656Value-659$Value$)/(Row656-Row$659$). Obviously, the $ denotes the values would be set. There are six different variables, and they are their own group. How can I do this with Alteryx?
Data is attached.
