Overwrite record in Mapper

Content

Hi Team,

   I have been trying to figure out a way for the below logic:

 

I have a file, which has records like below:

000PAM222604659MOWBRAY, SWATHY               101456      050 20191208   005
000PAM222604659MOWBRAY, SWATHY               101456      050 20191208   006

(005 and 006 is ID field)

from the above file, I want to write only the record which has the latest ID i.e 006 from the above two records.

I tried using

1. javascript, but we cannot wirte the output array to OIC.

2. Two for loops, looping through each record and writing the record. But overwriting the latest record is the issue.

Please provide your suggestions!!

 

 

Version

19