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

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!