Hi All,
I have business requirement in File(txt) to proxy scenario that to sort the values of a particular field which comes one time in each record and numeric value based on the other field in the source file.
Sort field : Amount
Base filed: Document_Number
Ex source file:
Document_Number Amount
00001 1245666
00001 3246566
00001 4567888
00001
00002 2323266
00002
00002 1235666
00003
00003 1254455
00003 6656565
Output format after sorting should be below: (For each document number in first record Amount filed has to be blank)
Document_Number Amount
00001
00001 1245666
00001 3246566
00001 4567888
00002
00002 2323266
00002 1235666
00003
00003 1254455
00003 6656565