Filling empty cells in a column with the last value

user03941

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  

 

 

 

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

 

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.

MarkSnodgrass

You should try what @jaeW_at_Onyx suggested in this thread: 

https://dojo.domo.com/t5/New-to-Domo-and-Admin-questions/Fill-down-values-in-a-column-in-DOMO-ETL/m-p/51399#M2410

 

You are on the right track using the Rank function.

MarkSnodgrass

You should try what @jaeW_at_Onyx suggested in this thread: 

https://dojo.domo.com/t5/New-to-Domo-and-Admin-questions/Fill-down-values-in-a-column-in-DOMO-ETL/m-p/51399#M2410

 

You are on the right track using the Rank function.