Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with the info for those employees with FTE (Full Time Equivalent) not equal to 100%.
The fields are:
Company - Employee - FTE - WeekDay - WorkingHours - FromDate - ToDate
Using IntervalMatch() I can join these info to a calendar table, but I get data only for those employees.
Is there a way to set default values for all the other employees, i.e. those with FTE = 100%, based on Company value?
You can also try ApplyMap. You can pass the default values through ApplyMap.
You can also try ApplyMap. You can pass the default values through ApplyMap.