Date Wildcards in ETL?
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.” -Superman
______________________________________________________________________________________________2
Answers
-
Thanks so much! This worked beautifully.
0
Categories
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有