Skip to Content
0
May 20, 2020 at 11:11 AM

How to Sort the filed values in each record SAP PO

60 Views

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