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…