Mass upload to remove absence reason to null using HDL
Hi,
Sick leave absence reason updated incorrectly and we need to remove the reason and make it null for the absence applied.
Note: Sick leave reason is not mandatory for this type.
Provided below HDL for sample used and it's not working as expected. Any experts please suggest how to remove the updated reason and make it as null through HDL.
METADATA|PersonAbsenceEntry|Employer|PersonNumber|AbsenceType|AbsenceReason|AbsenceStatus|ApprovalStatus|StartDatetime|StartDateDuration|EndDatetime|EndDateDuration|StartDate|StartTime|EndDate|EndTime|Duration
MERGE|PersonAbsenceEntry|LadbrokesBetting&GamingLimited|1108192|Sicknesshours|#NULL|SUBMITTED|APPROVED||3|||2023/02/09|00:00|2023/02/11|23:59|3
or
METADATA|PersonAbsenceEntry|Employer|PersonNumber|PerAbsenceEntryId|AbsenceType|AbsenceReason|StartDate|StartTime|EndDate|EndTime|Duration|AbsenceStatus|ApprovalStatus