How to know when a value is null for the first time in a sequence of run by changes?
Summary:
How to know when a value is null for the first time in a sequence of run by changes?
Content (required):
My HCM Extract is daily scheduled. Only values that change from a run to the other one are written in the output file. These are 3 variables that changes over 3 consecutive runs:
1) First time every value is extracted:
CurrentDate = 21/07/2023
CompensationEndDate = 22/07/2023
CompensationValue = 100
2) Second time nothing changes so no value is extracted
CurrentDate = 22/07/2023
CompensationEndDate = 22/07/2023 (CompensationEndDate_OLD = 22/07/2023) but since it's equal to its previous value it doesn't show on output
CompensationValue = 100 (CompensationValue _OLD =100) but since it's equal to its previous value it doesn't show on output