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
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman2
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
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman2 -
Thanks so much! This worked beautifully.
0
Categories
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive