Missing values handling

Hello knime community,

I need help handling some missing values from a database and also sorting the column headers from the latest to the most recent (purple). The idea is that the first missing values (red) have the value “0”, for example, the first four missing values in the column 2022-11-01 should be 0. On the other hand, the missing values marked in green should have the previous value. For example, in the column 2022-11-04 the missing value in the row 23 and 24 should be 5,020.

How can I handle this?

Data Base

Hope I was clear enouhg!

Best regards!

Try

First with previous value option and then with value 0.

3 Likes

Agreed with this one. I have used it myself in similar circumstances :slight_smile: