Re: Identify matching values in script based on certain criteria
Since the flag has to be set for both the values I have sorted the data twice. We don't have any function like below() in script level in order to create flag.
In the first load, I have created a TempIdentity flag by sorting the DMBTR.absolute and SHKZG fields in ascending order.
If( (SHKZG = 'S' andPeek('SHKZG') ='H') And (DMBTR.absolute = Peek('DMBTR.absolute')), 'x') asTempidentity Resident Data OrderbyDMBTR.absolute, SHKZG;
In the next step, I have created the identity flag by sorting the data SHKZG field in descending order. but I want to keep the previously created x in the final result. So finally to get the desired output I have created the identity field which uses the previously created field (Tempidentity)