Holidays between two dates
Dataset A contains date_start and date_end.
Dataset B is a calendar with a field called is_company_holiday.
I need to figure out a way (in Magic ETL 2.0) to create a value in Dataset A that tells me the number of holidays between date_start and date_end.
Anyone got any good suggestions?
Thanks to previous threads that have helped me get this far. @MarkSnodgrass in particular has been helpful. Thank you.
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 903 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 234 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 572 日本支部