SORT: Inserting Previous row Data into the Succeding Row
Posted: Thu Jul 30, 2015 9:48 pm
Is this possible to achieve this following transformation using Syncsort or DFSORT ?
EDOOO row can be followed by either by single BC1000 or both BC1000 and BC2000.
Input
ED0000 XXXXX
BC1000
BC2000
ED0000 YYYYYY
BC1000
ED0000 ZZZZZ
BC1000
ED0000 AAAAA
Expected Output
ED0000 XXXXX
BC1000 XXXXX
BC2000 XXXXX
ED0000 YYYYYY
BC1000 YYYYYY
ED0000 ZZZZZ
BC1000 ZZZZZ
ED0000 AAAAA
EDOOO row can be followed by either by single BC1000 or both BC1000 and BC2000.
Input
ED0000 XXXXX
BC1000
BC2000
ED0000 YYYYYY
BC1000
ED0000 ZZZZZ
BC1000
ED0000 AAAAA
Expected Output
ED0000 XXXXX
BC1000 XXXXX
BC2000 XXXXX
ED0000 YYYYYY
BC1000 YYYYYY
ED0000 ZZZZZ
BC1000 ZZZZZ
ED0000 AAAAA