Is there a processor that is able to fill NULL values with other values in the same column?
The concrete use case is:
I have a table that contains machine data with measurements of different temperature sensors. Every ten miliseconds the machine writes a value for temperature 1, ten milisecons later a value for temperature 2, ten miliseconds later for temperature 3 and so on. And after lets say 10 seconds it starts again with temperature 1.
The table we have therefore looks like this (the empty fields are NULL values in our case):
I would like to fill up the values and make it look like this (so the value measured for temp. 1 should be valid for the other timestamps as well)
Is there a processor to do that?
Currently we are using a python processor and a function of pandas (pandas.DataFrame.fillna — pandas 1.3.0 documentation) to make it possible, but this could potentially lead to issues once we increase the amount of data being loaded. We will have >1mio data points quickly.