cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

fill null values with next not null value in infotable

Regular Member

fill null values with next not null value in infotable

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

 

2 REPLIES 2

Re: fill null values with next not null value in infotable

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.

Re: fill null values with next not null value in infotable

Hi effpt3,

 

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

 

Best,

abarki