Date Wildcards in ETL?
I need to create a data flow where results are limited to the current month.
Right now I'm using >= Sept 1, 2019 and <= Sept 30,2019 for the results I need, but if a wildcard for current month is possible, I can avoid having to update the ETL each month.
Any suggestions?
Best Answer
-
I would use three tiles to do this in ETL. First you need to create a constant field that will contain the current date. Then you perform a date operation to find the month of your date field (called `Date` in my dataset) and the month of the Current Date that was just added. Finally, you can filter your dataset to only include rows where the "Month of Date Field" is equal to "Current Month".
You will need to make sure that this dataset updates at least once per day so that the current date and current month stay... well, current
2
Answers
-
I would use three tiles to do this in ETL. First you need to create a constant field that will contain the current date. Then you perform a date operation to find the month of your date field (called `Date` in my dataset) and the month of the Current Date that was just added. Finally, you can filter your dataset to only include rows where the "Month of Date Field" is equal to "Current Month".
You will need to make sure that this dataset updates at least once per day so that the current date and current month stay... well, current
2 -
Thanks so much! This worked beautifully.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 803 Beast Mode
- 79 App Studio
- 44 Variables
- 758 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 73 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