I have the following requirement that I am working on to implement the solution
Input
Code: Select all
Emp_HistID| Emp_NO|EMP_TYPE
100*1 100 H
100*2 100 RH
100*3 100 H
100*4 100 R
100*5 100 R
100*6 100 RH
100*7 100 H
100*8 100 R
100*9 100 V
100*10 100 RH
Code: Select all
Emp_HistID |Emp_NO|EMP_TYPE| EMP_STATUS
100*7 100 H ACTIVE
100*10 100 RH NA
Code: Select all
1. Is to check for a latest EMP_TYPE='H' and populate EMP_STATUS ='ACTIVE'
2.If EMP_TYPE changes from H to RH then it should populate as 'NA'
JobDesign Draft :
Code: Select all
seqfile(Input) -->RMD stage -->xfm-->seqfile(ouput)
Please let me know any ideas to implement this logic while I was testing
Thank you