Alteryx Designer Desktop Discussions

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

replace null value with last previous value in the same column based on criteria

jordanscraw
6 - Meteoroid

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

 

jordanscraw_0-1576096780947.png

10 REPLIES 10
Divyalingwal
5 - Atom

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

Labels