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.

Find more posts tagged with

Accepted answers

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.

All comments

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.