Issue with updating one segment people group via HDL
Summary:
We have a requirement to delete the people group value for certain inactive assignment records. The people group comprises only one segment. I use below format for this purpose, but it does not remove the PPG value unless I include some other column and update it along with it. It seems to be a bug with the HDL process, anyone has any idea if it is a bug or there is a workaround?
HDL file that doesn't work:
METADATA|WorkTerms|AssignmentNumber|ActionCode|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|EffectiveEndDate|PersonNumber|LegalEmployerName|WorkerType|DateStart
MERGE|WorkTerms|ET9999999|ASG_CHANGE|Y|1|2024/06/02|4712/12/31|9999999|LEVal|E|2019/12/01
METADATA|Assignment|AssignmentNumber|WorkTermsNumber|ActionCode|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|EffectiveEndDate|PeopleGroup