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
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.
0
Best Answer
-
You should try what @jaeW_at_Onyx suggested in this thread:
You are on the right track using the Rank function.
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 42 Domo News
- 9.9K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 267 Domo Best Practices
- 12 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 110 Apps
- 726 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 29 お知らせ
- 65 Kowaza
- 302 仲間に相談
- 664 ひらめき共有