AZA: Split Absence Entries
Hi Team,
Does anyone know how can we split the absence entries.
Example: If employee applies for a 3 days sick absence from 01-May-2022 to 03-May-2022 (single entry with absence start date May1 and end date May3). When we query the data in the BI we will get a single record but how can we split the absence into 3 rows with like below
Date Duration
01-May-2022 1
02-May-2022 1
03-May-2022 1
Any pointers much appreciated
Thanks in advance
Regards,
Ahmed
1