I would like to update the null values in the following table to equal the last previous price in the table based on a couple of criteria. For example, on record 2, where the WHS and RESC columns match, I would like to fill the value from the previous month (2002_10) into the month missing pricing data (2002_11). How can I accomplish this in Alteryx?
The values in the table below would be as updated to the following for the records which are currently null.
2. 0.00
4. 0.0357
5. 0.0357
7. 0.0472
Solved! Go to Solution.
Hi @RKahle , Did you get a solution to this problem. I also want to do something similar, i want to replace null with the last non-null value rather than the last value since i have multiple nulls one after another