fill null values with next not null value in infotable

[effpt3]

I have a infotable with some columns (timestamp, DT, TEMC, etc;) and values are some null and double.

I need to replace the null with previous value. If previous value is also null, then I need to replace with next not null value. Please help me out.

Find attachment for my infotable

[PaiChung · Accepted solution]

Please keep in mind that null is different from undefined

You either just loop through it and check each value and replace it,

Or you could use derive fields to generate a new column

if they are null you can use the following in the expression

columnname ? columnname : "nullreplacementvalue"

 but that can't get you previous value unfortunately.

[abarki]

Hi effpt3,

If PaiChung answered you question, kindly mark the post as accepted solution, this will benefit other community members.

Best,

abarki