Is there a way to duplicate a value one row down?
I have a column with a numeric value and null value every other cell. I want to replace the null cells with the numeric value that is directly above it.
Thanks in advance!
Answers
-
You can use the window function tile in Magic ETL. The function want to apply is LAG.
This article gives more info, scroll down to the Rank & Window Tile section:
1 -
Is there a way I could do this using an add formula tile; the Rank & Window tile does not seem to work.
For context, every odd row has a value in this column and every even row is null. I'm trying to fill the cells in the even rows with the value right above it.
I'm trying to use the lag function in the add formula tile, but is seems that it isn't a recognized function for the add formula tile.
0 -
Could you clarify the problem you're having with Rank & Window? @ST_-Superman-_ is correct in saying that the Lag function is what you want.
A lag of 1 will give you a new column whose values are all offset by 1 from those of its source column. That's not a complete solution, though, since you'll still have nulls in every other value. The next step is to use Add Formula with the "coalesce" function to make a column that has the non-null value from either the original or the lagged column, like so:COALESCE(my_original_column, my_lag_colum)
Randall Oveson <randall.oveson@domo.com>
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 703 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive