Filling empty cells in a column with the last value

Hi there,

 

I am currently stuck in a problem to fill empty cells of a column with the last value that is stated in that column. 

So I would like that the the cells of the column 'Cost Center Basis' are filled with the last stated value e.g. 'Kostenstelle/-träger: 1000010Bezeichnung: O001 General' until the next value is stated in the column. 

 

Below is a sample of how the dataset looks like  

 

Sample Data.PNG

 

 

And this is how I would like to have the result: 

 

Final Dataset.PNG

Does anyone know a way how to solve this problem either in Magic ETL or SQL? What's the best practise to solve this kind of problem?

 

Thanks in advance.

Best Answer

Answers