Select rows from a datset based on Date
Hi,
I have a dataset with one column as Date. Now I want to create an ETL process to create a new Dataset from the existing one based on rows which correspond top 10 days in the Date column of the existing data.
I checked on the available options for ETL but failed to see any direct way to do this. Only option that is close to my issue is to select a particular day from date-selector or to select the current day - which is not exactly what I wanted.
Is there any way to create a dataset based on only top few days in the existing one?
Comments
-
You could do this with using the row number function of rank and window and then use the filter to function.
Here is the KB article for rank and window and row number.
Basically, you would use the row number function to number your rows 1 - n. Then, you would use the filter function to only keep rows where row number is less than or equal to 10.
Hope this helps.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 797 Beast Mode
- 78 App Studio
- 44 Variables
- 757 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 72 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive