Intervalmatch default value

[SergioS]

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?

[Saravanan_Desingh · Accepted solution]

You can also try ApplyMap. You can pass the default values through ApplyMap.